Microsoft SQL Server Backup

  • Database hot backup
  • In-File Delta incremental backup
  • Unlimited retention
  • Local, LAN / WAN backup
  • Fast multi-thread backup
  • Flexible scheduling
  • Secure 256-bit encryption
  • Transaction Log Backup

Deployment for ZERO1’s Microsoft SQL Server backup solution is simply a breeze. You just need to install the client backup application on the SQL Server that you intend to back up. A wizard will guide you through creating a backup set, including selection of backup mode (VSS or ODBC), configuration of the backup source, backup schedule, retention policy, destination and encryption. Once the setup is done, the SQL Server databases will be automatically backed up to the selected destination(s), such as local storage, network share, or the zero1 offsite backup server according to your defined schedule(s).

The client supports transaction log backup using ODBC method. Two backup methods are available for MS SQL Server, namely VSS and ODBC:

NOTE: Recommended free space on the temporary folder should be 150% of the total database size for one backup destination (based on default Delta ratio setting of 50%), 200% of the database size for two backup destinations, 250% of the database size for three backup destinations etc.

Configuring a SQL Backup Set is Easy!

Launch the ZERO1 client and click “Backup Sets”.
Click “Add new backup set”
Choose “MS SQL Server Backup” from the drop down list and give your new backup set a name.
Choose the backup mode that is best for your environment.
Select the database(s) you wish to protect.
You can elect to go with the default schedule, modify it, or create your own schedule from scratch.
Select “zero1 Server” to backup your data offsite to the ZERO1 servers.
You can also choose to write a second backup to a local device. In this example, we choose to create a copy of the backup that is being sent to ZERO1 to the server’s local “F” drive. Alternatively, we could have chosen to write this second backup to a UNC path, a USB hard drive, etc.
Choose your Backup Mode.
Confirm the encryption passphrase you will use to encrypt your data.
Your backup set is now complete… Click “Backup Now” to begin your first backup.
The next screen will show you the progress of your backup. If you opted to write a copy of your backup to a local device, first it will backup to ZERO1, then it will backup to your local device. The offsite and local backups will be generated via the same snapshot.
Success!