SQL Backup & Database Protection

Backup and restore specific databases or a complete SQL server. BackupAssist’s SQL backup will help minimize your RPO for Microsoft SQL.

Near-continuous backups use transactional logging to minimize your Recovery Point Objective (RPO) and protect your SQL databases as frequently as every 5 minutes.
Live SQL Backups so you can back up your SQL databases while they are in use.
Backup multiple SQL Severs with a single backup job, whether those servers are local or remote, from one machine using a single BackupAssist installation.
SQL backups for Hyper-V and CSV environments – no matter how you run your SQL Server, BackupAssist will backup and restore your SQL data.
Create a tailored solution to restore either individual databases or your full SQL Server.
Quick, easy restores of your SQL backups with a dedicated, fully-featured restore tool catered specifically to SQL.

Scalable SQL backup

You can make a customized SQL backup job that meets the needs of your backup strategy with BackupAssist’s SQL protection.  Your local machine will be automatically scanned for any SQL Servers, which will be presented for your selection in a drop-down list.

After selecting your server you’re then presented with a list of databases, meaning you can customize each backup job according to the data you want to protect.   

Create backup jobs to protect both entire SQL servers and specific databases using BackupAssist’s SQL Protection.  It’s easy and comprehensive.


Near–continuous protection

With our SQL Protection Add-on, once you have selected the databases to back up, you can select either a Basic or a Near-continuous schedule for the backup job:

  • Basic backup schedule: Perform a daily backup of your SQL Server, while it is in use.
  • Near–continuous backups: This schedule performs transaction log backups throughout the day to cut your RPO to a minimum.

With the near-continuous capabilities of the SQL Protection Add-on, your data can be protected at 5 minute or greater intervals.  This provides the ongoing protection your ever changing databases need without the high costs of clustering or replication.

Combining the two SQL backup types gives you even greater protection.  You can run a transaction level backup throughout the day, as well as a full Server backup each night.


Customize your backup destination

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

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

Managing multiple backups means you have multiple restore points if one of your backups is corrupted or unusual. 


Restore your SQL databases to a point in time

When dealing with SQL databases, it’s important to be able to restore to a given point in time.  BackupAssist achieves this with a dedicated SQL restore tool designed for simple, effective and fast restores of SQL databases and servers.

With the SQL restore tool, you can:

  • View local SQL servers available for data restoration
  • Restore to a remote SQL server by name or IP address
  • Restore a master database if, for example, your SQL database is being recreated
  • Restore to specific company (user) databases
  • Enter a point in time, and the restore tool will locate the transactional backups closest to that point, reducing your RPO
  • Restore individual database transactions
  • Restore incomplete transactions
  • Roll a restored database, file, file-group or page forward to the point of failure

Comparison of the SQL Server support provided by the SQL Add-on and BackupAssist’s standard backup types

SQL protection

SQL Add on

Standard backup types

Full Server backup

Selected database backup

Continuous transaction level backups

Full Server restores

Selected database restores

Point-in-time restores

Remote SQL Server backup and restores


Specifications

  • Licensing
    BackupAssist SQL Server Add-on
  • Supported SQL Servers
    SQL 2014, 2012, 2008 R2, 2008, 2005 & 2000

Customer testimonials

"We have 3 servers, 2 with [competitor] and one that wasn't backing up. I was looking for a solution for the 3rd server but didn't want to pay for [competitor].

"Your application was... much easier to use with the same level of protection."

"I'm glad that we found BackupAssist. Whilst we realise the importance of backups ourselves, it has always been difficult to sell to clients in small to medium business when we had to include software with a $1000+ price tag. BackupAssist will make the sale much easier not only because of the price tag, but because we KNOW that it works so well."

"NTBackup scheduling is clumsy and unreliable. Client did not want to spend on [major competitors'] products."

"Another Computer consultant evaluated, purchased and recommended this software to Network Integration Solutions Inc. Since then, we are so impressed, that as far as I'm concerned any of our new servers will have a license of BackupAssist to make the media management simple."

Relied on by

Talk about this page:

Follow us on Spiceworks