Moving Master Data base
MOVING MASTER DATABASE
* Create two folders and grant read write permissions to service account
d:\master_data
e:\master_log
* Find the current path
sp_helpdb master
* Stop SQL Server
net stop mssqlserver
* Move the files (master.mdf, mastlog.ldf) into new folders
* Go to SSCM --> R.C on respective instance SQL Server Service --> properties --> Advanced --> Startup Parameters--> Change the path of data and Log file
-dd:\master_data\master.mdf;-e....
-le:\master_log\mastlog.ldf
* Apply --> OK
* Start the service.
* Go to SSMS --> check the new path
sp_helpdb master
