SnapProtect - Troubleshooting - SQL Server iDataAgent

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
  • Ensure 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 SnapProtect 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 SnapProtect backup job
  • Ensure that the Unconditionally Overwrite restore option is selected for SQL Server iDataAgent. If this option is not selected, restores of SnapProtect 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

If using Windows 2003 cluster, then use the instruction at http://support.microsoft.com/kb/903650.

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

If using Windows 2003 cluster, then use the instruction at http://support.microsoft.com/kb/903650.

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

If using Windows 2003 cluster, then use the instruction at http://support.microsoft.com/kb/903650.