The master database failed to restore. Use the rebuildm utility to rebuild the master database. Shutting down SQL Server.

Details
Product: SQL Server
Event ID: 3151
Source: MSSQLServer
Version: 10.0
Component: SQLEngine
Symbolic Name: LDDB_MASTER_LOAD_FAILED
Message: Failed to restore master database. Shutting down SQL Server. Check the error logs, and rebuild the master database. For more information about how to rebuild the master database, see SQL Server Books Online.
   
Explanation

This is a general error message indicating various problems with the
master
database.

   
User Action

Check the error logs for more information. To create a usable
master
database, run Setup.exe with the REBUILDDATABASE option. For more information see “How to: Install SQL Server from the Command Prompt” in SQL Server Books Online.

   
   
Version: 9.00.1281.60
Symbolic Name: LDDB_MASTER_LOAD_FAILED
Message: Failed to restore master database. Shutting down SQL Server. Check the error logs, and rebuild the master database. For more information about how to rebuild the master database, see SQL Server Books Online.
   
Explanation

This is a general error message indicating various problems with the master database.

   
User Action

Check the error logs for more information. To create a usable master database, run setup.exe with the REBUILDDATABASE option. For more information see “How to: Rebuild the Master Database for SQL Server 2005” in SQL Server 2005 Books Online.

   
   
Version: 9.0
Component: SQLEngine
Symbolic Name: LDDB_MASTER_LOAD_FAILED
Message: Failed to restore master database. Shutting down SQL Server. Check the error logs, and rebuild the master database. For more information about how to rebuild the master database, see SQL Server Books Online.
   
Explanation

This is a general error message indicating various problems with the
master
database.

   
User Action

Check the error logs for more information. To create a usable
master
database, run setup.exe with the REBUILDDATABASE option. For more information see “How to: Rebuild the Master Database for SQL Server 2005” in SQL Server 2005 Books Online.

   
   
Version: 8.0
Component: SQL Engine
Message: The master database failed to restore. Use the rebuildm utility to rebuild the master database. Shutting down SQL Server.
   
Explanation
The backup of the master database that you are restoring is not usable. The file itself may have been corrupted, or the original master database from which the backup was taken may have data integrity problems.
   
User Action
Follow these steps:

  • If the original master database from which the backup was taken is available, verify the integrity of the original master database with DBCC CHECKDB.
  • Verify the itegrity of the media on which the backup resides.
  • Verify the integrity and accessibility of the destination for the restore, and check that the SQL Server startup account has access to read from and write to that location.
  • If possible, create a new backup of the master database and test a restore of the new backup file.
  • If all attempts to restore the master database backup fails, you may, depending on your needs, want to consider using rebuildm to rebuild the master database from scratch.

Related:

Leave a Reply