Restoring the master database

You can restore the master database after you restart SQL using database copies.

See About restoring the SQL master database.

See Restarting SQL using database copies.

To restore the master database

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. On the Properties pane, under Source, click Selections.

  4. On the restore selections list, select the backup set containing the last master database backup.

  5. On the Properties pane, under Settings, click Microsoft SQL.

  6. On the Restore Job Properties for SQL dialog box, select Automate master database restore.

    All existing users are logged off, and SQL Server is put into single-user mode.

    When this option is selected, only the master database can be restored; if this option is selected for any other database, those jobs will fail.

    If Backup Exec does not have access to the SQL registry keys HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server and HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer, then a restore to the default directory may not work, and the option Automate master database restore on the restore job properties for SQL will not work. To ensure that Backup Exec has access rights, verify that the account that Backup Exec uses has administrator rights to the computer that is running SQL.

  7. Select a consistency check to be run after the restore.

  8. Start the restore job.

    After the restore, SQL restarts in multi-user mode.

  9. Restore the remaining SQL databases.

More Information

Restoring data by setting job properties

Restoring the master database