X hits on this document





168 / 200


Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images

master database restore option, and then restore any other databases, if needed.

If copies of the master and model databases were not made, then you must use Microsoft’s rebuildm.exe utility to rebuild the master database and start SQL.

Because all changes made to the master database after the last backup was created are lost when the backup is restored, the changes must be reapplied. If any user databases were created after the master database was backed up, those databases cannot be accessed until the databases are restored from backups or reattached to 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 and model database copies from a backup set to the same directory that 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.

For example:

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. Type the following: C:\Program Files\Microsoft SQL Server\MSSQL\Data>rename master$4idr master.mdf 3

C:\Program Files\Microsoft SQL Server\MSSQL\Data>rename 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

4 5

Use the SQL Service Control Manager to start SQL Server.

Continue with the next procedure to restore the latest changes to the master database.

To restore the master database


Log on as Administrator.

Document info
Document views331
Page views331
Page last viewedWed Oct 26 15:24:50 UTC 2016