May 4, 2010 at 12:01 pm
I currently have a 2 node SQL Server 2005 Test Cluster. I am trying to add a database to the test cluster. I have copied the dotCMS-dev.mdf backup from another cluster to R:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup. When I try to restore the dotCMS_dev database (file), I get the following error message:Restore failed for Server 'SQLVSERVERTEST1\SQLCLUSTERTEST1'. (Microsoft.SqlServer.Smo). System.Data.SqlClient.SqlError: Cannot use file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\dotCMS-dev.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. (Microsoft.SqlServer.Smo)
What do I need to do?
Thanks,
KinRon
May 4, 2010 at 12:06 pm
RonKin (5/4/2010)
I currently have a 2 node SQL Server 2005 Test Cluster. I am trying to add a database to the test cluster. I have copied the dotCMS-dev.mdf backup from another cluster to R:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup. When I try to restore the dotCMS_dev database (file), I get the following error message:Restore failed for Server 'SQLVSERVERTEST1\SQLCLUSTERTEST1'. (Microsoft.SqlServer.Smo). System.Data.SqlClient.SqlError: Cannot use file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\dotCMS-dev.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. (Microsoft.SqlServer.Smo)What do I need to do?
Thanks,
KinRon
You can't "restore" a copied "mdf" file. You have to make a backup of the database (usual file extension is *.BAK).
Also, it sounds like you have not made that disk a clustered resource. SQL needs to have a dependency on all disk;s that you want to use. And the C drive is local, it can never be used for a clusterd disk.
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
May 4, 2010 at 1:39 pm
Ok, thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply