Skip to main content
NetApp Knowledge Base

Unable to clone the SQL DB in snapcenter

  1. Last updated
  2. Save as PDF
Views:
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • NetApp SnapCenter Server (all versions)
  • SQL Server plug-in for SnapCenter
  • Windows Server (hosting SQL and SnapCenter plug-in)
  • Environments using iSCSI SAN connectivity for SQL data volumes

Issue

  • When attempting to clone a SQL Database using SnapCenter, the clone operation fails during the filesystem clone stage. The following errors are observed in SnapCenter job logs:

    Log Output:

    ERROR SCW_xxxxx PID=[6768] TID=[102] Failed to get disk information [81HSx?TCFqjk]. Please check if there is SAN connectivity between the host/hypervisor and storage controller.

    ERROR SMCore_xxxxx PID=[9656] TID=[24] ErrorCode(-1), ErrorMessage(Failed to mount disk 81HSx?TCFqjk to mount point [C:\\scmnpt\\mpdisk0075\\]. Failed to add access path to the partition. Details: Failed to get disk information [81HSx?TCFqjk]. Please check if there is SAN connectivity between the host/hypervisor and storage controller.)

  • Interestingly the same SQL server is able to clone same database from another SnapMirror Destination SVM fine.

      Symptoms:

  • SQL clone job fails during filesystem clone/mount stage.
  • The same SQL server can successfully clone from another SnapMirror destination SVM but fails from the newly created SnapMirror destination volume in the SnapMirror source SVM  .
  • All backups on the new volume fail to clone.
  • SnapCenter cannot discover or mount disks associated with the new volume.

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.