Restore SQL Server Data
You can browse and restore backed up data for your subclient, partial database or an entire database.
Your objective for restoring data determines the process you must follow and the restore destination.
|Disaster recovery||Plan your full system recovery in advance.|
|Recover data from long-term storage||If you back up your data to tape for long-term storage, you must identify the corresponding media, and make sure that it is available for the recovery operation.|
|Restore data from a specified time range||If you need to restore data during a range of time (for example, data that was deleted accidentally), you can browse and restore data based on a time range that you specify. Typically, this data would be restored to an out-of-place destination.|
|Restore to a point in time||If your SQL database becomes corrupted or otherwise invalid, you can restore the database to a point in time before the database became unusable. Typically, this data would be restored to an in-place destination.|
You can restore backed-up data by using the following methods:
- CommCell Console
You can perform the browse and restore operation from the CommCell Console.
- Command Line
The Command Line Interface provides a way to restore data from the command line, as an alternative to the CommCell Console, where various restore options can be specified either as parameters on the command line or in a separate arguments file. For more information, see Command Line documentation.
Consider the following factors when planning your restore strategy.
To what degree does data need to be restored?
- To restore all or part of a client's data, you can perform a Browse and Restore operation from the CommCell Console. If the system is not available, but the media is intact, then use Media Explorer to perform the restore.
- To restore the full system (operating system and application) on a client, perform a Full System Recovery: SQL Server Agent.
Do you need to restore data from the latest available backup data or from a previous point in time?
- To browse and restore to a point in time, see:
- To browse and restore from the latest data, see Browse the Latest Data.
In a basic restore, you can restore point-in-time data by specifying the time range options in the Advanced Restore Options (Time Range) dialog box.
For instructions, see Browsing and Restoring Data between Specified Backup Times.
- When you change storage policy for a default subclient, and later want to restore to a point in time prior to the change of the storage policy, you must perform a full backup of the database. Data from the old storage policy is not considered as the recent cycle, so the data is pruned if it exceeds its retention period.
When you select a restore time, the software determines the optimal combination of full backup, differential backup, and log backups necessary to bring the restored databases back to the selected time. This combination of backups is called the restore chain.
- For basic database restores, the restore chain consists of the most recent full backup, the latest differential backup (if any), and all the subsequent log backups (if any) taken prior to the selected restore time.
- While restoring databases to a transaction mark or during a point-in-time restore, the restore chain consists of the most recent full backup, the latest differential backup (if any), all the subsequent log backups taken prior to the selected browse time, and the next log backup after the transparent browse time. The transparent inclusion enables restores to a selected point in time.
The destination where you restore data is determined by your restore objective. Generally, you perform an in-place or an out-of-place restore.
When you restore a database in place, you restore it to the same path on the same client from which the database was backed up.
When you restore a database out of place, you can restore it to any one of the following destinations:
- A different client from which the database was backed up
- A different path on the same client from which the database was backed up
- A different database
You can perform in-place and out-of-place restores from the command line interface.