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,
Showing posts with label databae. Show all posts
Showing posts with label databae. Show all posts
Friday, February 10, 2012
Cannot restore databae successfully
Labels:
backed,
citrix_db,
databae,
database,
enterprise,
manager,
microsoft,
mssql,
mysql,
oracle,
restore,
server,
sql,
standalone,
successfully
Subscribe to:
Posts (Atom)