View Source


{kb-symptom}
Scenario: MS SQL is installed on the system drive (C\:) with databases on another drive (D\:) in the same machine.



{kb-cause}
The VSS snapshot mechanism for Windows OS's by default will only snapshot one partition at a time. This will cause the database(s) on the non snapshot drive to be out of sync with the MS SQL Server and that will affect data integrity.



{kb-resolution}
There is a new feature in 4.x that allows more than one partition (drive) to be chosen for the VSS snapshot process that will resolve this problem. You will find this setting in the Policy under Advanced Policy Settings. Note: when this new feature is enabled VSS will snapshot ALL drives local to that OS at the same time.


{code}
Multi-Volume Snapshot
{code}

{kb-related-articles}