Friday, February 10, 2012

Cannot restore databae successfully

Hi all,
I backed up a database called Citrix_DB through Enterprise Manager from a standalone MSSQL 2000. I tried to restore the DB to another MSSQL 2000 Cluster but failed. Would anyone know how to get it fixed? Thanks a lot. And below is the error message: -
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. File 'Citrix_DB_Data' cannot be restored to 'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. File 'Citrix_DB_Log' cannot be restored to 'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF'. Use WITH MOVE to identify a valid location for the file.
RESTORE DATABASE is terminating abnormally.
Regards,
On your new cluster, you have not made drive E: a dependency for SQL Server.
If you have a shared drive E:, then:
1) Take SQL Server offline
2) Create a disk resource for drive E:
3) Bring up the properties for the SQL Server service and make drive E: a
dependency
4) Bring the SQL Server group online
5) Restore your DB
If you don't have a drive E:, then restore the backup to another drive which
is a dependency for SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"vt2006" <someone@.somewhere.com> wrote in message
news:uYNrFdH8GHA.4572@.TK2MSFTNGP02.phx.gbl...
Hi all,
I backed up a database called Citrix_DB through Enterprise Manager from a
standalone MSSQL 2000. I tried to restore the DB to another MSSQL 2000
Cluster but failed. Would anyone know how to get it fixed? Thanks a lot. And
below is the error message: -
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF' for clustered
server. Only formatted files on which the cluster resource of the server has
a dependency can be used. File 'Citrix_DB_Data' cannot be restored to
'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF'. Use WITH MOVE to identify a
valid location for the file.
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF' for clustered
server. Only formatted files on which the cluster resource of the server has
a dependency can be used. File 'Citrix_DB_Log' cannot be restored to
'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF'. Use WITH MOVE to identify a
valid location for the file.
RESTORE DATABASE is terminating abnormally.
Regards,

No comments:

Post a Comment