SQL FCI restore error: "This operation is only supported on data partitions"
Applies to
SnapCenter Server 4.2+
SQL Server Failover Cluster Instance (FCI) 2016+
Issue
SnapCenter On Premise restore failing for SQL databases in Failover Cluster environment.
Error message:
No resources mounted from snapshot for restore
[screenshot]
SmCore Log file
<SmRestoreResponse>
ErrorMessage (Restore failed. Details: Error: No resources mounted from snapshot for restore.)
</SmRestoreResponse>
SnapCenterJobLogs log file
[...] Failed to initialize the disk: error = The access path is not valid.
[...] Failed to set the partition attribute: error = This operation is only supported on data partitions.
[...] Failed to set the partition attribute: error = This operation is only supported on data partitions.
[...] Failed to mount the resource: G:\LOG\ from snapshot: <snapshot_name>.
[...] Failed to mount the resource: G:\DATA\ from snapshot: <snapshot_name>.
[...] Failed to set the partition attribute: error = This operation is only supported on data partitions.