Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When Macrium Reflect takes an image is taken, Macrium Reflect invokes VSSit invokes Volume Shadow Copy Service (VSS). This is a Microsoft component which will take takes a point-in-time snapshot of your filesystemfile system. This will then remain remains active until the imaging is complete. For the majority of data , this is enough to create a backup , that when restored will result results in a consistent systemsystem when restored. 

An exception are database data. Database However, database engines cache transactions for performance purposes and it . It is important to force the engine to ensure that everything is on disk and in a coherent before the snapshot is taken.
In the case of

MS SQL server, Server includes a ' VSS writer ' is supplied that handles this automaticallyand automatically creates a coherent point-in-time snapshot. However, for databases that don't ship with a VSS writer, we you need to make an extra step when configuring the backup.

Create the following batch file (replace <XML File Name> with the name of your XML definition file):

<XML File Name>_before_snapshot_wait.bat

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.

Also, create Create the following batch file
<XML File Name> _after_snapshot _wait.bat

Save the file in the same folder as the backup XML file and make sure it contains the command(s) to start the db service.

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

Note
Visual Basic (vbs) and executable (exe) files can also be invoked using the same naming convention.

...