Using Volume Shadow Copy Service OK for backing up SQL Server Compact?
- by Troy
Would one expect a backup of a SQL Server Compact database file created with Volume Shadow Copy Service expected to be consistent?  I know the big SQL Server has a VSS writer to ensure consistency.  If a connection is writing out to a SQL Server Compact database could the file be backed up in a inconsistent state?