commvault.com commvault.com
Solved

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

  • 9 October 2021
  • 4 replies
  • 139 views
S
Rank
Badge +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???

icon

Best answer by Mike Struening RETIRED 21 October 2021, 23:17

View original

4 replies

Mike Struening RETIRED
Rank
Userlevel 7
Badge +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
Rank
Badge +3

Confirmed - I’ve escalated the case this morning.

Mike Struening RETIRED
Rank
Userlevel 7
Badge +23

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

https://www.linkedin.com/in/michael-struening
Mike Struening RETIRED
Rank
Userlevel 7
Badge +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


Terms & ConditionsCookie settings