SQL Server Performance Forum – Threads Archive
Single user mode in 2005Hi experts,
How do i take my instance in single user mode in sql 2005? Any idea, Is any body performed rebuild master database?
Swaamy Swamy Sirigineedi
Referhttp://msdn2.microsoft.com/en-us/library/ms188236.aspx to start your server in Single user mode.
and refer msdn2.microsoft.com/en-us/ms143269.aspx to rebuild master database. Regards
Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
it is same as SQL 2000. sqlservr.exe -m -c -sInstanceName you have step by step master db restores in this link. http://tech.groups.yahoo.com/group/sqlcon/message/4575 Madhu
Be aware there are issues with restoring a database using the GUI in 2005. Things do not work as advertised and after speaking with Microsoft today we found they are aware of the problem. You may need to use SQLQuery/Query Analyzer to restore a database. When we use the GUI with 2005 EE to restore the master database we receive an error because the GUI tries to create a second connection which single user mode does not allow. Dave
Thanks for the feedback Dave, incidentally this was discussed with one of the MS Dev.team in the PASS conference. But I haven’t tried the same so far. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.