While recovering a SQL database, you can choose from the following advanced restore options:
-
Recover Only: Specifies that the restore operation must recover the databases to an available online state. No data is actually written and all the other options are disabled when this option is selected.
-
Partial Restore: Partial restores, known as Piecemeal Restore in SQL Server 2005, allow databases that contain multiple file groups to be restored and recovered in stages. The process starts with a restore of the primary file group, then a restore or recovery of one or more secondary file groups.
-
Latest Backup Data: Allows restores of the latest backup data on one or more non-system secured databases in the SQL server. You can use this feature to create a spare copy of the primary SQL Server database (hot standby server) within the same domain, a different domain, or across a Wide Area Network (WAN).
-
Apply Log backups only: Only available when the Latest Backup Data option is selected. Select this option if you wish to include only the transaction log backups completed since the last restore operation. The restore operation will then skip any full backup jobs completed since the last restore operation.
Note
* Before selecting this option verify that the databases are in standby state or restoring state.
* If you do not select the Apply Log Backups Only option and the database already exists, all backup jobs completed since the last restore operation will automatically be restored.
* If you do not select the Apply Log Backups Only option and the database does not exist, the software will automatically perform a full restore of the database.
-
Skip Full Backup: Select this option to restore the differential backups and/or the transaction log backups since the last specified date and time, instead of the full backup. Select this option when you have restored the latest full backup by using third-party software, which means that you do not need to restore the full SQL Agent backup. Note that in such a case, you only select this option when a SQL Agent full backup exists that is more recent than the full backup currently restored on the client by third-party software.
-
Full Backup Only: Select this option to restore only the full backup of a database.
-
Verify Only: Select this option to run a restore validation job.
On successful validation, the restore job returns a successful message in the Commvault Event Viewer:
Query Result [the backup set on file 1 is valid]The restore validation job validates the following before running a restore operation:
* The volumes have sufficient permission to restore the database files.
* The header fields of the database pages exist at the destination.
* The restore destination device has sufficient space.
-
Keep Change Data Capture: Specifies to restore SQL 2008 or more recent databases, if they were backed up with the Change Data Capture property enabled. With this property enabled, you can query a database for changed data. Querying a database for changed data is useful because all change activity (insert, update, and delete) is captured and applied to SQL tables. The details of the changes are available in an easily consumed relational format. This option does not apply to backups that were VSS-enabled or to IntelliSnap backups.
The keep_cdc option is not applicable for restores with no recovery. The option can only be used during a database restore with recovery.