SQL Server Performance Forum – Threads Archive
Copy Database to clustered serverI am trying to copy a database from one SQL Server 2005 that is not clustered to one that is clustered. I get the following error and all of the help links are dead. I get the same error if I backup the first and try to restored it into the second. I have never worked with clustered server before. Will someone please give me a clue? Please and thank you,
Scott Sherman TITLE: Microsoft SQL Server Management Studio
—————————— Restore failed for Server ‘NG-SQL’. (Microsoft.SqlServer.Smo) For help, click:http://go.microsoft.com/fwlink?Prod…ceptionText&EvtID=Restore Server&LinkId=20476 ——————————
ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Cannot use file ‘Crogram Files (x86)Microsoft SQL ServerMSSQLDataNGExport.mdf’ for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. (Microsoft.SqlServer.Smo) For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.2047.00&LinkId=20476
You need to restore the database to a shared-drive that the cluster can see. Or you need to ‘move’ the database (however you can) to a shared disk on the cluster. The error indicates that you are trying to create/restore/attach/copy a database onto the C-Drive of a cluster node. The C-Drive of a cluster node is never a shared-disk. In cluster administrator (cluadmin.exe), look at the Dependancies for your SQL Server resource. You can restore the database to any disk listed that SQL Server is dependant on.
Thanks Haywood. The default location was to the C: drive. I copied the database over to the data drive of the cluster and then used attach database. It worked like a charm. Thanks again. Scott Sherman
You’re quite welcome. Those pesky defaults never work outside of a plain-jane install… <img src=’/community/emoticons/emotion-5.gif’ alt=’‘ />