SQL Server Backup Features Of The Offsite Backup Server
Hot backup of SQL Server databases.
Supports full and transaction log style backup.
Reliable backup using Microsoft SQL Server API (more reliable than open file type backup).
Schedule backups to run automatically.
Total disaster recovery protection - compress, encrypt and send backup data offsite automatically.
Easy to use. No scripting required.
How the SQL Server Backup Works
Start Backup.
Backup all databases within a Microsoft SQL Server to their backup files (*.bak) to a temporary directory.
Send all backup files (*.bak) from the temporary directory to the offsite backup server.
End Backup.
Notes :
The backup will start at its scheduled time automatically.
You can restore your database to any snapshot of your database in the past using time-based database restore.
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.
Online Backup Manager must be installed onto the machine running Microsoft SQL