You are here: Microsoft SQL Protection > Restoring SQL backups > Restoring the model and msdb databases

Restoring the model and msdb databases

Restoring the model and msdb databases is similar to restoring the master database in that they can only be restored back to their original server and SQL instance and that they must be restored individually. However, unlike restoring the master database, the SQL instance can be running at the time of the restore.

To restore the model or msdb database

1 Select a SQL icon in the Navigation pane and click Restore.
2 Select a Recovery Point Day from which the backup will be restored by clicking on the calendar. Available days display in bold.
3 Select a backup of the model or msdb database from the Recovery Point Times list.
4 Click Next (Select Options).

Note:  System databases must be restored individually. The multiple SQL restore feature is not supported for model and msdb databases.

5 (Optional) Check the Specify Target Pathname? box and supply an alternate path. By default, databases are restored to their original location.

Note:  Specifying an alternate pathname does not prevent your database from being overwritten.

6 (Optional) Specify pre- and post-backup commands by clicking the Show Advanced Execution Options icon. For details see Backup options New and View/Modify buttons.
7 Click Restore. The Restore Confirmation dialog box displays informing you that restoring the database without changing the name will overwrite the existing database. It is not possible to change the name of the model or msdb database. Check the check-box and click Confirm.
8 Click Okay on the Restore Status dialog box. You can view the status of your restore by navigating to Settings > System Monitoring > Jobs. For details, see Monitoring running restore jobs.