SQL 2005 Enterprise 64BIT Cluster, Adding Disk Resources

• richard.peace

  Newbie

  Points: 1

  More actions

  July 21, 2008 at 10:58 am

  #122663

  Hi Guys,

  What is the easiest way to Add a Disk Resource to a SQL Clustered Instance? I have Extra disks on my SAN which I have added into my MS Cluster but now want to add these into my SQL Cluster Instance, as I want to be able to seperate Log files from Data Files and Also Seperate my Master DB's as I will not be using my NET Apps Snap Manager to snap these.

  Regards

  Richard

• CyclingRabbit

  Say Hey Kid

  Points: 693

  More actions

  July 21, 2008 at 12:26 pm

  #845949

  (Make sure your SAN storage is already presented to your server and Windows can see it)

  Log in to Cluster Administrator.

  Open up the resource group where SQL Server is located.

  Right Click - > New -> Resource - Physical Disk

  Add your new Disk.

  Bring Cluster Offline (Right Click on resource node, click Take Offline)

  Double click the SQL Server resource and click on Dependencies

  Click Modify

  Add your new physical disk

  Save.

  Bring Cluster Online (Right Click on resource node, click Bring Online)

  You can now move database files onto the new disks.

  Cheers.

  -Alin