SQL Backup and Restoration

Backup and Restore specific databases or complete SQL servers with BackupAssist SQL Protection

"Backups-that-keep-up" - using transactional logging, the BackupAssist SQL add-on performs live and near-continuous backups of SQL databases.

"Live SQL backups" mean BackupAssist backs up your SQL Servers while your databases are in use.

BackupAssist uses a single backup job to backup multiple SQL Servers (local and remote) from one machine using a single BackupAssist installation.

Whether you operate a SQL Hyper-V solution or run SQL in a CSV environment, BackupAssist SQL Protection will backup and restore your SQL data.

Manage SQL system databases and your company databases, using a tailored solution to restore your company's data or a damaged SQL master database.

Select the SQL Servers to backup add-on

BackupAssist automatically scans your local machine for any SQL Servers and presents them for selection using a drop down list. Once your selection is made, a list of databases will be displayed for each SQL Server.

BackupAssist displays both SQL System and your own company databases, so you can make a customised SQL backup job that meets the needs of your backup strategy.

Complete SQL Server protection is achieved by using two in-built scheduling options:

• A Basic backup schedule that can be run daily to provide a complete backup of your SQL Server.
• A Transactional schedule that performs transaction log backups throughout the day.

These run at a minimum of every 15 minutes to ensure your changing data is protected. This acts as an ongoing incremental backup of your SQL Server and provides near-continuous protection (without the high costs of clustering or replication).

These layers of protection can be scheduled to work together:

• Before the day begins, perform a full backup of all databases.
• During the day, backup your databases at 15 minute intervals.

Customize your backup destination

Save your SQL Protection backups to secure, fixed media with a selection of custom options to manage:

• How long the backup are kept for
• How many backups are retained
• How much storage space each SQL backup can use.

Being able to manage multiple backs means you have multiple restore points and options if one of your backups is corrupted or unusable.

Restore your SQL databases

BackupAssist uses a dedicated SQL Restore tool to compliment the SQL Protection backup.

The SQL Restore Tool can:

• List the local SQL Servers that you can restore data to.
• Allow you to enter the name or IP address of a remote SQL Server to restore to.
• Give you the option to restore a master database (for example, if your SQL database needs to be recreated or replaced).
• Give you the option to restore specific company (user) databases.
• Allow you to enter a point in time and then display the transactional backups that you could use to restore a database as close as possible to that specific point in time.
• Migrate databases from one server to another.
• Restore an individual database to within 15 minutes of the most recent version.
• Restore individual database transactions.
• Restore incomplete transactions.
• Restore an SQL database to a specific point in time.
• And even ... roll a restored database, file, file group or page forward to the point of failure.