Specifications

• Full backup is created - Rolling Snapshots will be created immediately after

creation of the full backup

• Differential backup is created - Rolling Snapshots will be created immediately

after creation of the differential backup

• Transaction log backup is created - Rolling Snapshots will be created

immediately after the creation of the transaction log

Please be aware that it is not possible to create Rolling Snapshots of the master and

model system databases.

When Rolling snapshots are enabled, transaction logs will not be truncated.

Type the desired snapshot name prefix in the Name prefix field.

In the Maximum number of snapshots field, you can set the number of Rolling

Snapshots. For example if you maintain 8 snapshots the earliest snapshot will be deleted

automatically after the ninth snapshot is created.

Having defined the Rolling Snapshot creation options, click OK to save your settings.

Figure 20. Rolling snapshots options

Selecting System Databases to Back Up

Microsoft SQL Server maintains a set of system databases that are essential for the operation

of a server instance. You are encouraged to backup all system databases after every

significant change:

• master – records all the system-level information for a Microsoft SQL Server

instance