SQL Server Performance Forum – Threads Archive
Restoring DB form one SQL Cluster to anotherI 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.
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