SQL Server Performance Forum – Threads Archive
Adding new disk resources to existing cluster
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=’‘ /> <- 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
Add the disk as a dependency on the sql server resource properties. Then sql server will see it.
That did the trick. Thanks for the tip.
]]>