If the master database is critically damaged and SQL cannot be started, you can: replace the corrupted or missing databases with the copies of the master databases and model databases. Backup Exec automatically creates and updates these copies whenever backups of those databases are run. (Alternatively, restart SQL by running the Rebuild Master utility or reinstall SQL.)
After SQL is running again, you can restore the latest copy of the master database and restore any other databases, if needed.
If copies of the master databases and model databases were not made, then you must use Microsoft's rebuildm.exe utility to rebuild the master database and start SQL.
To restart SQL using database copies
Verify that the database copies are present.
The database copies are
named master$4idr
, mastlog$4idr
, model$4idr
, and modellog$4idr
.
In a default installation of SQL Server 2000, the databases are in:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\*.*.
In a named instance of SQL Server 2000, the databases are in:
C:\Program Files\Microsoft SQL Server\MSSQL$Instance_Name\Data\*.*
If necessary, restore the master database and model database copies from a backup set to the same directory. Restore them from the original master and model databases are in.
Open a command prompt window and delete the original master and model databases and their transaction logs.
C:\Program Files\Microsoft SQL Server\MSSQL\Data> del master.mdf mastlog.ldf model.mdf modellog.ldf
Rename the copies of the databases back to their original names.
C:\Program Files\Microsoft SQL Server\MSSQL\Data>rename master$4idr master.mdf C:\Program Files\Microsoft SQL Server\MSSQL\Data>ename mastlog$4idr mastlog.ldf C:\Program Files\Microsoft SQL Server\MSSQL\Data>rename model$4idr model.mdf C:\Program Files\Microsoft SQL Server\MSSQL\Data>rename modellog$4idr modellog.ldf
Continue with the procedure to restore the latest changes to the master database.
More Information