April 28, 2004 at 1:48 pm
I want to be able to recover a database (master, msdb, user) on a cluster server. All documents that I have read, indicate starting SQL Server in single user mode. I have not been successful at starting SQL Server in a single user mode on an Active/Passive virtual server. I have even shutdown the cluster services and the start up was still unsuccessful. Is there a way to start SQL Server on a cluster server in single user mode? Or the better question would be how do I restore databases (master, msdb, user) onto a cluster server?
May 3, 2004 at 8:00 am
This was removed by the editor as SPAM
May 5, 2004 at 1:17 pm
1) Take your resources offline.
2) Go to the command prompt and change your directory to the installation folder of your sql say c:\prog*files*\micr*sql ser*\
3) Change the directory to mssql\binn
4) Enter sqlservr -c -m
You can now start your restore. Don't bring your resources online still. Once you are done with your restore, shutdown sqlservr.exe and bring your resources online.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply