December 31, 2003 at 2:04 am
While creating a new DB using restore option on a cluster node, i am getting the following error..
Please let us know the solutions to correct.
Cannot use file 'H:\LOG\test_log.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. [SQLSTATE 42000] (Error 5184) File 'test_Log' cannot be restored to 'H:\LOG\test_log.ldf'. Use WITH MOVE to identify a valid location for the file. [SQLSTATE 42000] (Error 3156) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
regards
December 31, 2003 at 5:09 am
it reads the filelocations from the backup-set, so you'll have to change file-locations to those available on your clustered-sqlserver-instance.
e.g. :
Restore database mydb
from DISK = '\\myserver\drive$\msSQL\BACKUP\mydbFull.BAK'
with MOVE N'mydb_data' TO N'x:\MSSQL$instance\Data\mydb_data.mdf'
, MOVE N'mydb_data_2' TO N'y:\MSSQL$instance\Data\mydb_data_2.mdf'
, MOVE N'mydb_log' TO N'z:\MSSQL$instance\data\mydb_log.ldf'
, RECOVERY
ps: Happy NewYear
Edited by - alzdba on 12/31/2003 05:45:48 AM
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply