Error :SQL Server 2005 cluster config and trying to move database to a different drive/create a database “Only formatted files on which the cluster resource of the server has a dependency can be used.Either the disk resource containing the file is not present in the cluster group or the cluster”


For the SQL Server resource we need to add a dependency of the drive to which we are moving the database and log files.
 
1. Right click the SQL Server resource under Groups and click Properties.
 
2. Click on dependency tab and add the disk LUN.
 
Note : You will need to take the resource group offline to accomplish this solution and bring it back online once the change has been completed.
 
 
 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s