Saturday 25 June 2016

Moving Master Database files




Moving Master Database Files:

  •  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

No comments:

Post a Comment