3

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?

abatishchev
  • 98,240
  • 88
  • 296
  • 433
Troy
  • 1,237
  • 2
  • 13
  • 27

1 Answers1

2

backup files are called "crash-consistent" when there is no writer service. you may be missing the recent updates, but usually good. ofcourse, depends on how critical your data or application is.

JMS77
  • 558
  • 2
  • 5
  • 13
  • So, I suppose since SQL CE is in-process, my own application would have to act as the writer service by receiving notification that a backup is about to occur. – Troy Jul 21 '10 at 02:01
  • It would have to, not sure the SQL CE code will do that automatically for you. Did you manage to find an answer here? – Hannes de Jager Feb 22 '11 at 13:16