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
welcome to shbcf.ru