Restoring the master Database

If master is damaged in some way, for example due to media failure, Microsoft® SQL Server™ may not be able to start if the damage is severe. There are two methods to return master to a usable state:


Important Keep a current backup of master; rebuilding master using the Rebuild Master utility causes all data stored previously in master to be lost permanently.


If SQL Server can be started because master is accessible, and at least partly usable, it is possible to restore master from a backup like any other database. However, if SQL Server cannot be started because of severe damage to master, it is not possible to restore a backup of master immediately because SQL Server needs to be running to restore any database. The master database first needs to be rebuilt using the Rebuild Master utility, and the current backup can be restored as normal.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.