SQL Backup and Restoration

BackupAssist's SQL Backup Engine allows you to backup SQL Servers with a choice of either daily backups or near-continuous backups (every 15 minutes), and backing up specific databases or complete servers.

And with a Restore Wizard that makes database recovery simple, BackupAssist is a great way of protecting your databases and the applications that sit on top of SQL Server.

Licensing

BackupAssist SQL Server Add-on

Supported SQL Servers

SQL Server 2000, 2005, 2008 (all variants)

Method

SQL backup in standard .bak format.

Resources

Brochure

White paper

Highlights

Backup any number of local or remote (networked) SQL Servers from one machine (using only one add-on license)
Choose between daily backups or near-continuous data protection
Capture a "live snapshot" of your databases, so the SQL Server can be running during the backup
Perform Transation-log backups of your SQL databases for specific point-in-time restoration of databases
Restore an entire SQL server or individual databases using the built-in SQL Restore utility

Select the SQL Servers to backup

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

Basic protection - daily backups

Backup on a daily basis at a specified time

Superior protection - 15-minute incremental backups

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

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

Choose how many backups to keep

Keeping multiple backups is highly recommended, as it:

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