4 database support – Acronis True Image 9.1 Server for Windows - User Guide User Manual

Page 34

Unchecking the Do not perform operations until the commands execution is
complete box, checked by default, will permit the backup process to run concurrently with
your commands execution.

5.3.4 Database support

Database servers, such as MS SQL Server and MS Exchange, prove to be troublesome to
backup, partially due to open files and indexes and partially due to rapid data changes.
Therefore it is usually recommended that the database be suspended just before the backup
(data capture) moment. Provided all transactions are completed by the moment of data
capture, the database, when recovered, will be ready to access immediately after recovery.
1. Volume Shadow Copy Service
Microsoft Volume Shadow Copy Service (VSS) provides the infrastructure for backup
on running systems by keeping up coordination between user applications that update data
on disk and backup applications. VSS is available in Microsoft Windows XP and Microsoft
Windows Server 2003 operating systems.
If your database is compatible with Microsoft Volume Shadow Copy Service (VSS),
then checking the Enable VSS support box in Database support window will ensure
completion of all transactions before the backup process starts. The examples of VSS-aware
databases are Exchange, Oracle, SQL Server.
2. Before/after data capture commands
However, VSS is not available in server operation systems older than Windows 2003
Server, and not all databases support VSS. In these cases, the transactions completion can
be ensured with executing batch files or scripts that pause the appropriate Windows services
and automatically resume them after data capture.
An example of a batch file, suspending the Windows services for MS Exchange:

net stop msexchangesa /y /y

net stop “Microsoft Exchange Routing Engine”

An example of a batch file, resuming the Windows services for MS Exchange:

net start “Microsoft Exchange System Attendant”

net start “Microsoft Exchange Event”

net start “Microsoft Exchange IMAP4”

net start “Microsoft Exchange MTA Stacks”

net start “Microsoft Exchange POP3”

net start “Microsoft Exchange Routing Engine”

Create batch files in any text editor (for example, name it ‘pause_services.bat’ and
‘resume_services.bat’). Use Edit buttons to the right of Before data capture command
and After data capture command fields, to open the Edit Command window where you
can browse folders to find the respective batch files or scripts. A single command can be
specified in the same window along with its arguments and working directory.
It is critical to note that these commands, as opposed to Backup commands above, will be
executed before and after

data capture

process, which takes seconds, while the entire

backup procedure may take quite long time. Therefore, the database idle time will be
minimal.