Export (0) Print
Expand All
0 out of 5 rated this helpful - Rate this topic

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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.