December 31, 2010 at 10:03 pm
While moving the .mdf and .ldf files of master database from one drive to another drive, why should we start the instance in master-only recovery mode? Found the below in msdn site.
"Start the instance of SQL Server in master-only recovery mode by entering one of the following commands at the command prompt. The parameters specified in these commands are case sensitive. The commands fail when the parameters are not specified as shown.
For the default (MSSQLSERVER) instance, run the following command.
NET START MSSQLSERVER /f /T3608
For a named instance, run the following command.
NET START MSSQL$instancename /f /T3608"
Please let me know
Thank you!!! and Happy New year
January 2, 2011 at 11:10 am
According to this MSDN page
http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.100).aspx
recovering in master-only mode is only necessary when following the Failure Recovery Procedure.
For just moving the master DB, you can follow the instructions described in the corresponding paragraph.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 4, 2011 at 4:20 am
Thanks for the reply.. I would like to know why should we keep the master database in "master only recovery mode". What happens if we don't keep it in the master only recovery mode while following the procedure.
Thank you
January 4, 2011 at 4:33 am
karthik.catchme (1/4/2011)
I would like to know why should we keep the master database in "master only recovery mode". What happens if we don't keep it in the master only recovery mode while following the procedure.
You will not be able to recover the master database.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply