Home / server / Questions / 311524
Accepted
SidC
Asked: 2011-09-15 14:54:35 +0800 CST

What Steps are Required to Restore SQL Server 2005 Master Database used with Sharepoint 2007?

  • 772

The master database on our SQL Server 2005 instance appears to be corrupted. Since this database powers our MOSS 2007 installation, what steps must be taken to restore master and ensure that MOSS 2007 is restored as well?

Thanks!

sql-server-2005 sharepoint-2007

1 Answers

  1. Best Answer

    If you are sure that it is corrupt, then keep reading. But first, are you completely sure that it is corrupt? How have you decided that it's corrupt? (Sorry to ask, but restoring the master database is a really big deal.)

    Assuming that you have a backup of the master database you'll need to stop the SQL Service and restart the instance by running it from the command line by using the -c -f -m switches. This is done from what ever folder the SQL Server binaries are in "c:\program files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\binn" by default.

    sqlservr -c -f -m

    This will start the SQL Server in the command window. Then connect with SQLCMD in another window and use the RESTORE DATABASE statement to restore the database database from the most recent backup. The instance should shutdown automatically. Restart it and the database should come back online.

    • 2