A database snapshot is a read-only, static view of a database (the source database). The database snapshot is transactionally consistent with the source database as of the moment of the snapshot's creation, minus any uncommitted transactions.

Snapshot backups capture changes to the database, and are used for maintaining historical data for report generation, safeguarding data against administrative and user error, and managing a test database. See Snapshot.

Note

For information about limitations when creating a snapshot of a SQL Server DBVM see Microsoft SQL Server.

Log in to Data Director as a user with appropriate privileges.

Create Snapshots

Create External Backups

Delete Snapshots

Delete External Backups

Recover

1

In Data Director, select the organization and click the Manage & Monitor tab.

2

In the navigation pane, select the database group, and click the down arrow to show the list of databases.

3

Right-click the database name and select Backup and Recovery, then select Take Manual Backup.

4

In the Take Manual Backup dialog, select the relevant manual backup options.

Action

Description

Type

Select Snapshot from the drop down menu.

Retention

Select how long to keep the snapshot backup.

Backup label

Type a name by which to identify the snapshot backup.

Schedule action

Select the Schedule action checkbox to specify a date and time to run the snapshot backup.

5

Click OK to start the snapshot process.

The database is unavailable while the snapshot operation is in progress.

Data Director takes a snapshot backup of your database.