Backing up SQL Servers (SQL Server 2000, 2005, 2008)

Using the BackupAssist SQL Add-on, you can:

• Backup any number of local or remote (networked) SQL Servers from one machine (using only one add-on license)
• Easily select the databases to backup
• Choose between daily backups or near-continuous data protection

Select the SQL Servers to backup

Simply point-and-click to select the SQL Servers, instances and databases to backup.

Select the SQL Servers and Databases to backup

Basic protection - daily backups

Backup on a daily basis at a specified time.

Basic protection - backup one per day

Superior protection - 15-minute incremental backups

Achieve near-continuous protection for SQL Server (without the high costs of clustering or replication):

1. Before the work day begins, perform a full backup of all databases
2. During the work day, backup your databases at 15 minute intervals (transaction log backup)

Near-continuous protection - backup every 5, 10, or 15 minutes

Choose how many backups to keep

Keeping multiple backups is highly recommended, as it:

1. Gives you multiple restore points
2. Means that if one backup becomes corrupt, you have an alternative to restore from

Keeping a backup history to enable different restore points