Skip to main content
NetApp Knowledge Base

SCSQL backups fail with error "Unable to find the database files"

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

Applies to

  • SnapCenter Server (SC)
  • SnapCenter Plug-in for Microsoft SQL Server (SCSQL)
  • SnapCenter Plug-in for Microsoft Windows (SCW)
  • Microsoft Storage Spaces SMP service (SMPHOST)

Issue

SCSQL backups for all SQL databases on a stand-alone or cluster host fail with the following errors:
 
SnapCenter UI:
Activity 'Discovering Resources' failed with error: Unable to find the database files : (<Database_Files>). Ensure that the storages are in valid state.
Activity 'Registering invalid databases' failed with error: Unable to find any healthy resource on NetApp storage.
 
SCW_<JobID_Date_Time>.log:
Verbose SDW PID=[<PID>] TID=[<TID>] GetHostFileSystem: Found 0 disks
Error SDW PID=[<PID>] TID=[<TID>] Failed to get resource object graphs using SMAPI. Error code: 0. Details: Failed to enumerate the disks.
Verbose SDW PID=[<PID>] TID=[<TID>] ++VirtualDiskDiscoveryManager::ResolveVirtualDiskStorageLayout
Error SDW PID=[<PID>] TID=[<TID>] Errror: The resource graph is null/empty
 
Application Event Viewer log on affected SQL host:
A timeout was reached (30000 milliseconds) while waiting for the Microsoft Storage Spaces SMP service to connect. The Microsoft Storage Spaces SMP service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.

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.