SQL Server Performance

Restoring DB form one SQL Cluster to another

Discussion in 'SQL Server Clustering' started by gjhuffman, Jun 17, 2004.

  1. gjhuffman New Member

    I get a failure when trying to restore a DB from an existing to node cluster a new two node cluster. The error is Cannot use file 'L:mssqllogsDBNAMElog.ldf. Only formatted on which the cluster node or server has a dependency can be used.'

    Any ideas.
  2. Twan New Member

    In cluster administrator

    take the SQL instance off line, then open the properties for the SQL Server resource and add all of the disks for that sql instance to the dependencies. When installing a cluster the SQL install program will only add a dependency for the first data drive no others

    Cheers
    Twan

Share This Page