Skip to main content
commvault.com commvault.com
Solved

Restore Microsoft SQL 2016 Databases - from Intellisnap Snapshots from Windows Cluster volumes

S
Bit
Forum|alt.badge.img+3

When I try to restore any database that was backed up using Commvault / Intellisnap operation, I get an error indicating the disk is in Read Only mode.

  1. The snap is presented to the cluster node - seen by Windows Disk Management and Diskpart
  2. The Cluster Management doesn’t see the disk, so I can’t put in maintenance mode
  3. The cluster.exe is nolonger available in Server 2016
  4. I need to put the disk in maintenance mode to allow the CV restore to proceed

Does anyone have an exact powershell script or method to finish this process?

Is there another way to restore SQL databases to the Cluster Source disk if it was backed up using snapshots???

Best answer by Mike Struening RETIRED

Sharing the solution:

Provided the steps below:

The source SQL cluster disk that hosted database/logs in question for the restore was set to maintenance mode on.

Put a cluster disks in maintenance mode in GUI. Here is also PowerShell command.

https://forsenergy.com/en-us/cluadmin/html/febf2913-017f-4cef-82fb-508340dec272.htm

https://docs.microsoft.com/en-us/powershell/module/failoverclusters/suspend-clusterresource?view=windowsserver2019-ps

https://documentation.commvault.com/11.24/expert/34631_intellisnap_troubleshooting_sql_server_agent.html

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

View original
Did this answer your question?

4 replies

Mike Struening
Vaulter
Forum|alt.badge.img+23

Hey @Smartodd , I’m looking to get someone on this one for you, though I see you have an incident open for what might be the same issue.

Can you confirm?  Either way, I want to get you an answer, just want to ensure we have the best resources on both :nerd:

https://www.linkedin.com/in/michael-struening
S
Bit
Forum|alt.badge.img+3
  • Smartodd
  • Author
  • Bit
  • 6 replies
  • October 11, 2021

Confirmed - I’ve escalated the case this morning.

Mike Struening
1 person likes this
  • Mike Struening
    Mike Struening
Mike Struening
Vaulter
Forum|alt.badge.img+23

Thank you!  I’ll keep an eye on the case.

https://www.linkedin.com/in/michael-struening
Mike Struening
Vaulter
Forum|alt.badge.img+23

Sharing the solution:

Provided the steps below:

The source SQL cluster disk that hosted database/logs in question for the restore was set to maintenance mode on.

Put a cluster disks in maintenance mode in GUI. Here is also PowerShell command.

https://forsenergy.com/en-us/cluadmin/html/febf2913-017f-4cef-82fb-508340dec272.htm

https://docs.microsoft.com/en-us/powershell/module/failoverclusters/suspend-clusterresource?view=windowsserver2019-ps

https://documentation.commvault.com/11.24/expert/34631_intellisnap_troubleshooting_sql_server_agent.html

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

https://www.linkedin.com/in/michael-struening

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings