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 |
|
Elidas
Starting Member
33 Posts |
 Posted - 2008-05-06 : 08:47:32
|
| I am using SQL Server 2000 and I am trying to migrate my old database to a new cluster of 2 nodes and 2 instances (active-active). Those are the steps I am doing:1- Backup of old DB2- Restoring the DB in the instance 2 of the second node using enterprise manager assistant3- While restoring the DB I select different disk partirions for the .mdf file and the .ldf file4- And then I get the following error: "Error 5184: Cannot use file 'L:\SQLlog\vene_log.ldf' for clustered server. Only formatted files on which the clustered resource of the server has a dependency can be used"Why do I get this error if I separate the mdf and ldf in different disk partitions and I get no error if I use the same partition?thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-05-06 : 09:13:19
|
| My guess (I'm no cluster expert). L drive is either no a cluster resource, or is not associated with SQL server in the cluster.--Gail Shaw |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-06 : 10:14:35
|
| The SQL Server you are restoring to needs to have the L:\ drive as a resource not only within the same group as SQL Server, but as a dependency. This is to ensure that the files on the L:\ drive follow the SQL Server during a failover, and that the drive is online before SQL Server attempts to start up. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 21:37:22
|
| If log path is different from l: on the cluster, you can use move option in restore to point log file to correct location. |
|
|
|
|
|
|
Cannot use file .ldf for clustered server