cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup 7.6.0.2 SQL 2012 cluster database restore

jeff_menil
Level 2

We have rebuilt our Windows 2012 servers hosting SQL 2012 server. SQL has been installed and configured on cluster and is now online. Disk resources are also configured on the cluster and accessible to the server. When we tried to restore SQL database with the MOVE option to a diffrerent location, we got this error:

DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <5184><[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use file 'T:\SQLData\Data\SQLt01d01.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.>.

DBMS MSG - SQL Message <3156><[Microsoft][ODBC SQL Server Driver][SQL Server]File 'SQLtDMD01d01' cannot be restored to 'T:\SQLData\Data\SQLt01d01.mdf'. Use WITH MOVE to identify a valid location for the file.>

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

See this?

https://support.microsoft.com/en-us/kb/295732

View solution in original post

3 REPLIES 3

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Is T Drive configured in the cluster?

jeff_menil
Level 2

Hi Riann,

 

Yes T: drive is configured on the cluster. SQLData\Data folders were also created.

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

See this?

https://support.microsoft.com/en-us/kb/295732