SQL Server Performance

Adding new disk resources to existing cluster

Discussion in 'SQL Server Clustering' started by zmully, Nov 2, 2005.

  1. zmully New Member

    Hello all-<br />I'm having an odd problem with my w2k clustered MSSQL2k setup. I recently added another set of disks to the RAID, creating another shared data drive. My setup is as follows:<br />Quorum (E<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Transaction logs (F<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />SQLDATA (G<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />SQLDATA2 (H<img src='/community/emoticons/emotion-1.gif' alt=':)' /> &lt;- new drives<br /><br />I have sucessfully added the new data drive to the cluster, but SQL server refuses to acknowledge it's existance. I've restarted the cluster entirely several times without sucess. Is there some trick to getting SQL server to recognize the new drive? And when I do, what is the recommended method for adding it? Create a new filegroup? or add it to the existing primary filegroup?<br /><br />Thanks,<br />Z
  2. Argyle New Member

    Add the disk as a dependency on the sql server resource properties. Then sql server will see it.
  3. zmully New Member

    That did the trick. Thanks for the tip.

Share This Page