22 How do I move a master database from one drive to another in SQL Server?

preview_player
Показать описание
How do I move a master database from one drive to another in SQL Server?

How do I move a master database from one drive to another in SQL Server?
How do I move a master database to another drive?
How do I change the database location in SQL Server?
How do I move a database from one drive to another in SQL Server?

Рекомендации по теме
Комментарии
Автор

Is it copy the master files or cut and paste the files on E drive
Both are entirely different

varrareddy
Автор

One more step to do after as per MSFT:

At this point SQL Server should run normally. However Microsoft recommends also adjusting the registry entry at SQL Server\instance_ID\Setup, where instance_ID is like MSSQL13.MSSQLSERVER. In that hive, change the SQLDataRoot value to the new path. Failure to update the registry can cause patching and upgrading to fail.

BloodUTUBE