After you install a SQL Server 2008 failover cluster in a disk that contains a mounted volume, no dependencies are created between the mounted volume and the disk

Article translations Article translations
Article ID: 956008 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario: You install a Microsoft SQL Server 2008 failover cluster in disk that contains a mounted volume. After the installation is complete, the mounted volume and the disk are added to the SQL Server cluster resource group. However, no dependencies are set between the mounted volume and the disk.

STATUS

This behavior is by design.

MORE INFORMATION

If no dependency exists between the mounted volume and the disk, data corruption may occur on failover. To prevent this kind of corruption, you must manually create a dependency between the mounted volume and the disk.
To help further automate the above process for multiple machines, visit the following Microsoft Technet Web site:
Customize the 2007 Office system to work with a non-Microsoft e-mail application http://technet.microsoft.com/en-us/library/dd630735.aspxAdditionally, each mounted volume must also be added as a SQL Server dependency. If only the root physical disks dependency is added and the mounted volumes are not added, database corruption will occur on failover.

Properties

Article ID: 956008 - Last Review: August 14, 2009 - Revision: 4.0
APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
Keywords: 
sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kbexpertiseadvanced kbtshoot kbprb KB956008

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com