Move Master Database from one drive to another in SQL server || Ms SQL

preview_player
Показать описание
In this video i have shown how to move Master database from one drive to another drive in SQL server.

Master database files path is determined by SQL Server's startup parameter.

After moving files, the SQL Server service account must have permission to access the files in the new file folder location.

How to move user database from one drive to another drive.
Click below to watch the video
Рекомендации по теме
Комментарии
Автор

Easy to understood and simple
Thank you sir

gangadharb
Автор

When you are moving User and System (all system dbs) db's, is there are order you should do this? Meaning, should i do the User Dbs first, then the model, temp, msdb, master?

Bullbluegill
Автор

Could you please also make videos on Always ON, like restoring DB's part of AO and patching and upgarding on AO. Thanks !

AT-tbhf
Автор

Nice explanation but while we tired I got an error

srimahesh
Автор

sp_helpfile also provides to help for physical file

srinathsriramoju
Автор

My sql server agent not start when i goes to start then error showing '' Request failed or service did not respond in timely fashion Consult event log and error details" i am doing every thing but not getting any result

smempire
Автор

nice explanation how we can get scripts

ogprqpz
Автор

Could you please share a Video to restore corrupted master database

kthotakuri
Автор

please do video on patching and upgrade

banalasiva