SnapManager enables you to verify the SQL Server databases stored on destination volumes: SnapMirror destination volumes and SnapVault secondary volumes (clustered Data ONTAP only). When verifying the integrity of databases on a destination volume, SnapManager automatically detects the existing relationships in the SQL Server volumes and selects the available relationship for the selected volume.
The "Choose SnapMirror Destination Volumes for Integrity Verification" window shows the relationship between the source and the destination volumes. Each volume is displayed as a tree showing the relationship between the storage and the databases. For each source volume, there is a list of destination volumes. You can select a destination volume for each source volume for which you want to verify integrity.
Click Backup Verification Settings in the Actions pane.
Result: The Verification Settings dialog box appears.
Click the SnapMirror and SnapVault Options tab.
Click the "Verification on Destination volumes" button.
Result SnapManager displays the Choose SnapMirror Destination Volumes for Integrity Verification window.
If the volume is not available, SnapManager displays an appropriate error message.
Select the destination volumes.
By default, SnapManager displays the "Number of Relationships" field. You cannot edit this value. If the SnapMirror destination volume is not in the SnapMirrored state or does not have FlexClone license installed, SnapManager displays an error message when you click Apply. Integrity verification completes for the source verification volume but fails for the destination volume.
Click Apply to save the changes.
Result: SnapManager saves the settings and makes it available whenever you launch the SnapManager application.
To run integrity verification on SnapMirror destination volumes, ensure that the following system configuration requirements are met:
You can run integrity verification on the SnapMirror destination volumes for different SnapManager operations:
Full database backup verification When you run integrity verification on the SnapMirror destination volume, SnapManager performs the following operations:
When the SnapMirror update replicates the backup to the selected destination, SnapManager continuously monitors the SnapMirror update activity through SnapDrive, as follows:
Deferred integrity verification For deferred integrity verification (that is, verification at some stage after the backup has been created), SnapManager verifies the SnapMirror state of the destination storage system volume and the existence of a backup Snapshot copy on it. If the Snapshot copy does not exist, SnapManager displays an error message.
When you run a deferred integrity verification on available SnapMirror destination volumes, SnapManager performs the following actions:
If the "SnapMirror update after operation" option is not selected, SnapManager updates the verification results only on the source SnapInfo volumes.
If the "SnapMirror update after operation" option is selected, the following actions occur:
If the backup is not available on the destination volume, SnapManager fails the mount operation for integrity verification and leaves the backup unverified. In this case, SnapManager does not request the SnapMirror update.
Mount Snapshot and Attach Database When you run an integrity verification for the Mount Snapshot and Attach Database operation, SnapManager performs the following tasks:
Restore When you run an integrity verification for a restore operation on the destination volume, SnapManager performs the following actions:
Remote verification When you run an integrity verification on the destination volume present on the remote destination, SnapManager performs the following actions: