Shared disk on Sql 2005 cluster environment

• Ayyappan Thangaraj

  Old Hand

  Points: 364

  More actions

  December 11, 2008 at 5:34 am

  #132858

  SQL 2005 CLUSTER RESOURCE DEPENDENCY CREATION

  I have taken this information from Microsoft support after i faced this problem given below.

  Cannot use file 'os_filename' for clustered server.

  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 resource of the Sql Server does not have a dependency on it.

  One or more files listed in the statement could not be found or could not be initialized. (Microsoft SQL Server, Error: 5184)

  Solution:

  1.Open the Cluster Administrator.

  2.Make sure that all the physical disk resources that contain SQL Server databases are in the same group as the SQL Server resource.

  3.Right-click the SQL Server resource, and then bring the resource into an Offline state by clicking Bring Offline.

  4.Right-click the SQL Server resource, and then click Properties.

  5.Click the Dependencies tab.

  6.Click Modify to add the disk to the dependencies list for that resource.

  7.Bring the SQL Server resource back online, and then put the SQL Server files on that shared cluster disk.

  Graphical representation:

  Open cluster administration page:

  Start>Run>Cluadmin .

  

  Goto your SQL group

  Select your SQL Instance and Right Click on it

  

  Click Dependencies tab and then click Modify button

  

  

  Select your resource from the Available resource list. Move it to dependencies.

  Click ok, Ok, then bring your group online.

  And do the same action. Now, you can access the shared cluster resource from SQL. 

  Thank you

  Ayyappan

  Feedback welcome with pleasure