Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
W00dY
Starting Member
8 Posts |
 Posted - 2009-02-08 : 13:53:35
|
| The disks, SQL Server, SQL Network Name, and SQL Network Address are all in the same group (SQL Group). I detached the test database, moved the data and log files to new LUNs, and tried to attach using the new files. I also tried attaching using the original files, for which the dependency had been moved. I get an error "Only formatted files on which the cluster resource of the server has a dependency can be used." in both cases.Old Dependencies--------Resource: SQL IP Address1(MQ1SQLVA)--------Resource: SQL Network Name(MQ1SQLVA)- dependency: SQL IP Address1(MQ1SQLVA)--------Resource: SQL Server- dependency: SQL Network Name(MQ1SQLVA)- dependency: Disk G:--------Resource: SQL Server Agent- dependency: SQL Server--------Resource: SQL Server Fulltext- dependency: SQL Server--------New Dependencies--------Resource: SQL IP Address1(MQ1SQLVA)- dependency: Disk D:- dependency: Disk F:- dependency: Disk G:- dependency: Disk H:- dependency: Disk I:- dependency: Disk J:- dependency: Disk K:- dependency: Disk L:- dependency: Disk M:- dependency: Disk N:- dependency: Disk O:- dependency: Disk P:- dependency: Disk Q:- dependency: Disk R:- dependency: Disk S:- dependency: Disk T:- dependency: Disk U:--------Resource: SQL Network Name(MQ1SQLVA)- dependency: SQL IP Address1(MQ1SQLVA)--------Resource: SQL Server- dependency: SQL Network Name(MQ1SQLVA)- dependency: Disk G:--------Resource: SQL Server Agent- dependency: SQL Server--------Resource: SQL Server Fulltext- dependency: SQL Server-------- |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-08 : 14:02:23
|
| http://support.microsoft.com/kb/295732 |
 |
|
|
|
|
|
Detach/Attach in a Sql Server 2000 Cluster