> Expert > Backup and Restore Agents > Snapshot Management > Supported Agents > Microsoft SQL Server

IntelliSnap - Troubleshooting - SQL Server Agent

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,

  1. Set the cluster resource disk maintenance mode to be ON with the command:

    cluster res "cluster disk #" /maint:on

  2. Revert

    After performing the revert operation, you must restart the SQL Server service so that the databases are re-linked to the data files

  3. 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

  1. Set the cluster resource disk maintenance mode to be ON with the command: 

    cluster res "cluster disk #" /maint:on

  2. Restore

  3. 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

  1. Set the cluster resource disk maintenance mode to be ON with the command: 

    cluster res "cluster disk #" /maint:on

  2. Mount

  3. 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.

Article ID: SQL0017

IntelliSnap backups for SQL Server on OS disk fail on EC2 instance

For more information, see KB article 78617

Loading...