Skip to end of metadata
Go to start of metadata

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: 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: Verifying VSS Works Correctly (Knowledge Base) Labels: vss, shadow_copy, ntbackup, wsbackup, snapshot
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
Labels:
vss vss Delete
multi-volume multi-volume Delete
snapshot snapshot Delete
shadow shadow Delete
copy copy Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.