Post reply

How to restore on a cluster server?

  • April 28, 2004 at 1:48 pm

    #111067

    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

    #505361

    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