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.