November 13, 2021 at 6:47 am
Below Script is getting failed
;RESTORE DATABASE [NTAFSDB] FROM DISK = 'D:\backup-NTA\NTAFSDB.bak'
WITH REPLACE, FILE = 1, NORECOVERY, STATS=10,
MOVE 'NTAFSDB' TO 'G:\SQL\NTAFSDB.mdf',
MOVE 'NTAFSDB_log' TO 'G:\SQL\NTAFSDB_log.ldf'
,MOVE 'NTAFSDB_NTAFLOWMEMORYSTORAGE' TO 'G:\SQL\NTAFSDB_NTAFLOWMEMORYSTORAGE'
;
RESTORE DATABASE [NTAFSDB] FROM DISK = 'D:\backup-NTA\NTAFSDB.bak'
WITH REPLACE, FILE = 1, NORECOVERY, STATS=10,
MOVE 'NTAFSDB' TO 'G:\SQL\NTAFSDB.mdf',
MOVE 'NTAFSDB_log2' TO 'G:\SQL\NTAFSDB_log2.ldf'
, MOVE 'NTAFSDB_NTAFLOWSTORAGE' TO 'G:\SQL\NTAFSDB_NTAFLOWSTORAGE.mdf'
, MOVE 'NTAFSDB_NTAFLOWSTORAGE' TO 'G:\SQL\NTAFSDB_NTAFLOWSTORAGE.mdf'
;RESTORE DATABASE [NTAFSDB] WITH RECOVERY
Error
Cannot use file 'G:\SQL\NTAFSDB.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.
Msg 3156, Level 16, State 3, Line 1
File 'NTAFSDB' cannot be restored to 'G:\SQL\NTAFSDB.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "L:\MSSQL13.SQLNTA\MSSQL\DATA\NTAFSDB_NTAFLOWSTORAGE.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'NTAFSDB_NTAFLOWSTORAGE' cannot be restored to 'L:\MSSQL13.SQLNTA\MSSQL\DATA\NTAFSDB_NTAFLOWSTORAGE.mdf'. Use WITH MOVE to identify a valid location for the file.
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'G:\SQL\NTAFSDB_log.ldf' 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.
Msg 3156, Level 16, State 3, Line 1
File 'NTAFSDB_log' cannot be restored to 'G:\SQL\NTAFSDB_log.ldf'. Use WITH MOVE to identify a valid location for the file.
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "M:\MSSQL13.SQLNTA\MSSQL\Log\NTAFSDB_log2.ldf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3156, Level 16, State 3, Line 1
File 'NTAFSDB_log2' cannot be restored to 'M:\MSSQL13.SQLNTA\MSSQL\Log\NTAFSDB_log2.ldf'. Use WITH MOVE to identify a valid location for the file.
Cannot use file 'G:\SQL\NTAFSDB_NTAFLOWMEMORYSTORAGE' 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.
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'G:\SQL\NTAFSDB_NTAFLOWMEMORYSTORAGE' 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.
Msg 3156, Level 16, State 3, Line 1
File 'NTAFSDB_NTAFLOWMEMORYSTORAGE' cannot be restored to 'G:\SQL\NTAFSDB_NTAFLOWMEMORYSTORAGE'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Completion time: 2021-11-13T01:34:40.9766321-05:00
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 13, 2021 at 7:19 am
Looks like the drives are not owned by the clustered role.
Verify in failover cluster manager what role owns the drive(s) you are trying to restore too.
If this is owned by another role, you will need to restore to the other instance.
If this is a new drive which has been added then you will need to tell the role that the new drive is for that SQL instance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply