1. Support
  2. Knowledge base
  3. 100020718

NetBackup for Microsoft SQL Server database move fails with ODBC error "Cannot use file '<path/file>.mdf' for clustered server."

Article: 100020718
Last Published: 2020-12-16
Ratings: 0 0
Product(s): NetBackup

Problem

NetBackup for Microsoft SQL Server database move fails with ODBC error "Cannot use file '.mdf' for clustered server."

 

Error Message

DBMS MSG - ODBC return code , SQL State , SQL Message .mdf' for clustered server.

 

Solution

Details:
NetBackup for Microsoft SQL Server database move exits with "Server status = 0", but fails to restore the data files on the client. The database is being restored to a clustered SQL Server instance.
 
Progress log:
DBMSMSG - ODBC return code <-1>, SQL State <37000>, SQL Message<5184><[Microsoft][SQL Native Client][SQL Server]Cannot use file'[drive:]\[path]\file.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.>.
DBMSMSG - SQL Message <3156><[Microsoft][SQL Native Client][SQL Server]File 'modeldev' cannot be restored to '[drive:]\[path]\file.mdf'. Use WITH MOVE to identify a valid location for the file.>
 
Resolution:
In the database move template, the path specified for the TO keywords must contain a drive that is present in the SQL cluster group.
 
Source:
  https://support.microsoft.com/kb/295732
 

 

Was this content helpful?

Article Languages