The master database must be accessible and at least partly usable for starting a SQL Server Instance. If the master database becomes unusable, you can return the database to a usable state by either restoring the master from a current database backup or rebuilding the master.
You can restore the master database from a Full Database backup only if you are able to start the server instance. If severe damage to the master database prevents you from starting the SQL Server, rebuilding the master is the only option left. For more information, see Rebuilding the master Database in the SQL Server Books Online.
The restoration of the master database includes:
• |
• |
Because the changes made to master since the last backup were lost, re‑create them by performing those steps again. |
• |
For more information, see Restoring data to an alternate SQL Server.
Restoring the model or msdb database from a backup is required under the following circumstances:
• |
The master database has been rebuilt. In this case, restore model from a backup because rebuilding master re-creates model. |
• |
Restoring model or msdb is the same as performing a Complete Database restore of a user database.
Before restoring msdb, the SQL Server Agent Service in the Control Panel must be stopped. Quest also recommends that you shut down applications, because the restore procedure disconnects users when necessary.
For more information, see Strategies for Backing Up and Restoring Snapshot and Transactional Replication and Strategies for Backing Up and Restoring Merge Replication sections in the SQL Server Books Online.
1 |
In the Navigation pane, click Create Restore Job. |
2 |
On the Create Restore Job — Choose Saveset page, select Plug‑in for SQL Server from the Plugin Type list. |
3 |
5 |
Click Next. |
6 |
On the Create Selection Set page, select the data that you want to restore. |
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center