831 - Backup script examples for ESE

Scripts can be run automatically from the ESE Agent by going to Options and Settings > Backup Scripts.

This can be useful to automate preparation tasks or to facilitate more complex backup orchestration. We've provided some examples below.

Microsoft SQL Server database dump backup

The ESE Agent can be used to backup SQL Server databases using the SQL Server VSS writer (from the SQL view). However, the VSS backup may not be suitable for a user who wants to perform transaction log backups for point in time recovery, as point in time recovery cannot be performed using a VSS backup.

See the example scripts.

MySQL dump backup

MySQL is not natively supported using the ESE Agent, but can be achieved using backup scripts.

See the example scripts.

Running PowerShell scripts

The ESE Agent supports running batch files or applications that do not require parameters. If running an application that requires parameters, these must be encapsulated in a batch file, like Microsoft PowerShell.

See the example script.

Shut down Windows after a backup

In some circumstances it may be desirable to shut down a computer after the backup completes.

See the example script.

System-state-only backup

The ESE Agent performs a full volume backup (known as "Windows Image Backup") for bare metal recovery and system state restores. To perform a system state backup only, as offered in the Server Edition's system state for WSB plugin, use this example.