SQL Backup and Restoration
- 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
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.
- 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
Resources