Skip to main content
NetApp Knowledge Base

SMSQL backup fails with error SnapDrive was unable to create a Snapshot copy of one or more LUNs

Last Updated:

Applies to

  • SnapDrive for Windows (SDW)
  • SnapManager for SQL (SMSQL)
  • ONTAP 9.1


  • Backup fails with error in the SMSQL job report:

Failed with error code 0xc0040850.
Error : Failed to create snapshot [<instance_name> : admin].
Error Details: [SnapDrive Error]: SnapDrive was unable to create a Snapshot copy of one or more LUNs that reside on different storage system volumes. All Snapshot copies that were created as part of this LUN Snapshot copy operation were deleted. Please check the application event log for more details.
(SnapDrive Error Code: 0xc00402c2)

  • First error seen in the Application Event logs on the SMSQL server:

    Failed to create snapshot of volume <volume_name> reason: cannot exceed maximum number of snapshot copies


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.