Symptom
Scenario: MS SQL is installed on the system drive (C:) with databases on another drive (D:) in the same machine.
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.
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.
Multi-Volume Snapshot
Related Articles
| Page: Error - Backups of MS SQL Server and Databases using MS SQL Addon not Working (Knowledge Base) Labels: mssql, sql, vss_writer, vss |
| Page: How much space does VSS need to create and maintain a snapshot? (Knowledge Base) Labels: vss |
| Page: How to view a Microsoft VSS snapshot in Windows File Explorer (Knowledge Base) Labels: vss, shadow, copy, vssadmin |
| Page: Multi Volume Shadow Copy with Windows Agents (Knowledge Base) Labels: vss, multi-volume, snapshot, shadow, copy |
| Page: Verifying VSS Works Correctly (Knowledge Base) Labels: vss, shadow_copy, ntbackup, wsbackup, snapshot |
| Page: How VSS Is Used By CDP (Knowledge Base) Labels: windows, vss |
| Page: Multi Volume Shadow Copy with Windows Agents (Knowledge Base) Labels: vss, multi-volume, snapshot, shadow, copy |
| Page: Multi Volume Shadow Copy with Windows Agents (Knowledge Base) Labels: vss, multi-volume, snapshot, shadow, copy |
| Page: Verifying VSS Works Correctly (Knowledge Base) Labels: vss, shadow_copy, ntbackup, wsbackup, snapshot |
| Page: How to view a Microsoft VSS snapshot in Windows File Explorer (Knowledge Base) Labels: vss, shadow, copy, vssadmin |
| Page: Multi Volume Shadow Copy with Windows Agents (Knowledge Base) Labels: vss, multi-volume, snapshot, shadow, copy |
| Page: How to view a Microsoft VSS snapshot in Windows File Explorer (Knowledge Base) Labels: vss, shadow, copy, vssadmin |
| Page: Multi Volume Shadow Copy with Windows Agents (Knowledge Base) Labels: vss, multi-volume, snapshot, shadow, copy |