Revert failure occurs for cluster restore
Symptom
You have a restore failure performing an application aware revert or performing a hardware specific revert.
Resolution
Before performing a revert operation:
-
RevertSnapVolume has been set to 1
-
Make sure the archived redo log files and their mirror log files reside on the same array volume
-
All the databases on a volume must be backed up using IntelliSnap backup, failing of which will make the data inconsistent
-
All the databases on a volume must be selected for the revert operation. Also, the databases must be backed up using a single IntelliSnap backup job
-
Ensure that the Unconditionally Overwrite restore option is selected for SQL Server iDataAgent. If this option is not selected, restores of IntelliSnap backup data will fail
-
On Windows clients, disable automount using the following command:
diskpart> automount disable
Now, follow these steps,
-
Set the cluster resource disk maintenance mode to be ON with the command:
cluster res "cluster disk #" /maint:on
-
Revert
After performing the revert operation, you must restart the SQL Server service so that the databases are re-linked to the data files
-
Set the cluster resource disk maintenance mode to be OFF with the command:
cluster res "cluster disk #" /maint:off
Cluster restore without specifying proxy failed
Symptom
Restoring cluster snap backup to the source failed.
Resolution
-
Set the cluster resource disk maintenance mode to be ON with the command:
cluster res "cluster disk #" /maint:on
-
Restore
-
Set the cluster resource disk maintenance mode to be OFF with the command:
cluster res "cluster disk #" /maint:off
Mounting snapshot to the cluster disk failed
Symptom
Mounting snapshots to a cluster disk destination failed.
Resolution
-
Set the cluster resource disk maintenance mode to be ON with the command:
cluster res "cluster disk #" /maint:on
-
Mount
-
Set the cluster resource disk maintenance mode to be OFF with the command:
cluster res "cluster disk #" /maint:off
Backup operation does not protect all the Always On Databases
Backup operation skips to protect Always On Databases that are a part of an instance in a cluster.
IntelliSnap backups for SQL Server on OS disk fail on EC2 instance
For more information, see KB article 78617