SQL Server Performance

Copy Database to clustered server

Discussion in 'SQL Server 2005 Clustering' started by sshermanwa, Mar 27, 2007.

  1. sshermanwa New Member

    I 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 'C:program 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


    Scott Sherman
  2. Haywood New Member

    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.
  3. sshermanwa New Member

    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
  4. Haywood New Member

    You're quite welcome. Those pesky defaults never work outside of a plain-jane install... <img src='/community/emoticons/emotion-5.gif' alt=';)' />

Share This Page