Page History

When Macrium Reflect takes an image, it invokes Volume Shadow Copy Service (VSS). This is a Microsoft component which that takes a point-in-time snapshot of your file system. This then snapshot remains active until the imaging is completecompletes. For the majority of data this is enough to create creates a backup that results in a consistent system when restoredsystem upon restore. 

However, database engines cache transactions for performance purposes. It is important to , therefore, to force the engine to ensure that everything is on the disk and coherent before the snapshot is taken.

MS SQL Server includes a VSS writer and automatically creates a coherent point-in-time snapshot. However, for databases that don't ship with a VSS writer, you need to make take an extra step steps when configuring the backup:

Note: The example below uses batch files. Create However, visual Basic (vbs) and executable (exe) files can also be invoked using the same naming convention.

1. Use Notepad to create the following batch file (replace <XML File Name> with the name of your XML definition file):

...

1. <XML File Name>_before_snapshot_wait.bat
2. Save the file in the same folder as the backup XML file and make sure it contains the command(s) to stop the db service.
3. Create the following batch file

...

1. : <XML

...

1.  File Name> _after_snapshot _wait.bat
2. Save the file in the same folder as the backup XML file and make sure it contains the

...

1. commands to start the

...

1. database service.

This ensures that the db database service is stopped for the duration of the snapshot creation phase, usually less than a minute.

...

...