You can only restore system databases from backups that are created on the version of SQL Server® that the instance is running. For example, to restore a system database on an instance that is running on SQL Server 2005 SP1, use a backup that was created after the instance was upgraded to SQL Server 2005 SP1.
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.
Replication supports restoring replicated databases to the same SQL Server® Instance and database from which the backup was created. If you restore a replicated database from a backup to a different instance, replication settings cannot be preserved. In this case, re-create all publications and subscriptions after backups are restored.
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.
A standard restore with Plug‑in for SQL Server in SQL Server includes the steps outlined in the following topics:
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. |
8 |
If you are restoring from a Partial Database backup and you want to restore only the modified data, use the following SQL Server® command to restore only the applicable items: |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center