SQL Server Backup Features in Offsite Backup Solutions

  • Hot backup SQL Server databases
     
  • Support full and transaction log style backup
     
  • 100% reliable backup using Microsoft SQL Server API (more reliable than open file type backup)
  • Schedule backup to run automatically
     
  • Total disaster recovery protection - compress, encrypt and send backup data  offsite automatically.
     
  • Easy to use. No scripting required.

How are SQL Server databases backup by Offsite Backup Solutions ?

  1. Start Backup
     
  2. Backup all databases within a Microsoft SQL Server to their backup files (*.bak) to a temporary directory
     
  3. Send all backup files (*.bak) from the temporary directory to the offsite backup server
     
  4. End Backup

Note:

  1. Backup will start at its scheduled time automatically.
  2. You can restore your database to any snapshot of your database in the past using time-based database restore.
  3. If you choose to run incremental backup rather than full backup as stated above, the backup files (*.bak) created in step 2 above will be incremental backup files.
  4. Online Backup Manager must be installed onto the machine running Microsoft SQL Server.