Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Considerations for Rebuilding the master Database

SQL Server 2005

Updated: 14 April 2006

When damaged, the master database must be rebuilt if:

  • A current backup of master is not available.
  • A backup of master exists, but it cannot be restored because the instance of Microsoft SQL Server cannot start.
ms191431.note(en-US,SQL.90).gifNote:
If you are using the full recovery model for msdb, which is recommended, before rebuilding master, you should try taking a tail-log backup of msdb. For more information, see Tail-Log Backups.

In SQL Server 2005, the Rebuildm.exe program has been discontinued. For information on how to rebuild master, see How to: Install SQL Server 2005 from the Command Prompt.

ms191431.note(en-US,SQL.90).gifImportant:
Rebuilding the master database installs all system databases to their initial location. If you have moved one or more system databases to a different location, you must move the databases again. For more information about moving system databases, see Moving System Databases.

Release History

14 April 2006

New content:
  • Added note about local of system databases.

5 December 2005

New content:
  • Recommended attempting a tail-log backup of msdb—if it uses the full recovery model.

Community Additions

ADD
Show:
© 2015 Microsoft