Considerations for Rebuilding the master Database
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.
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.
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.
Help and Information
14 April 2006
5 December 2005