MS SQL Database Backup and Restore
Protect Microsoft SQL Databases Through Zmanda
Zmanda MS SQL Agent provides the perfect, cost-effective solution for protecting all your Microsoft SQL databases. IT Teams can quickly backup or recover Microsoft SQL databases while the databases are still online. Zmanda ensures that resilience planning is simplified empowering IT teams while offering a cost-effective solution.
Now With Simplified Licensing
Or talk to our sales executive at 888-496-2632 (US) or 408-732-3208 (INTL)
1 million
servers under backup.
Open Audits
Audits available through Amanda.
Coverity Rung 2 Certified
Homeland Security standard to certify products for Government use.
Workings of MS SQL Client
Zmanda Client for MS SQL uses the Microsoft Volume Shadow Services to back up the SQL database(s) and logs. Depending on the service enabled on the server, ZWC uses either the SQL Server VSS Writer or the MSDE Writer.
Key Features
No Downtime
Backup Microsoft SQL Server databases to a single master backup server without impacting active users or applications.
Rapid Recovery
Databases can even be restored to a different host through a simple and intuitive central management console.
Flexible Backup Levels
Supports full and multi-level incremental backups using industry-standard data formats.
VSS Support
Microsoft SQL client uses Volume Shadow Copy Service (VSS) writer to ensure reliability during hot backups.
How we benefit you?
Hybrid Cloud Backups
Seamlessly integrate with Amazon Web Services, Google Cloud Platform, Microsoft Azure, and many more for long-term-retention, disaster recovery, and cloud-native backups. Easily assign Legacy Tapes for Vaults for compliance and cost-benefit reasons.
Intelligent scheduling
A unique scheduler optimizes the backup level for different clients in a way that equalizes the total backup time from one backup run to the next. Network and hardware resources are used as efficiently as possible.
Real-Time Optimization
Zmanda scheduler optimizes Backup Runs across multiple clients to use Network and hardware resources as efficiently as possible.
Compression and Encryption
With Zmanda, you can be sure that your data will be saved in a compressed format to optimize space while your data won’t be accessed by someone who shouldn’t have access to it.
Testimonials
We pour our hearts into creating the most reliable backup solutions, and our customers testify to our commitment.
Zmanda guarantees end to end data integrity and easy storage... They provide fixes for our issues and respond very quickly every time.
Marcin Mazurek, Infrastructure & IT Operations Director at Allegro
We have a stable system always updated. We sleep well.
Leonardo Corato, ICT manager at VDP Fonderia
As long as you're a little bit technical, I can't see any reason to use any other product than Amanda Enterprise
Johan Hybinette, Chief Information Security Officer at Schryver Medical
Frequently Asked Questions
When the Zmanda Client for Windows is configured and licensed for Microsoft SQL backup, it uses the Microsoft Volume Shadow Services to back up SQL database(s) and logs. Depending on which, service is enabled on the server, ZWC uses either the SQL Server VSS Writer or the MSDE Writer. ZWC does not use the MS-SQL API for SQL database backup.
ZWC performs an incremental backup of databases and transaction log files just as it does any other file system backup (based on modification time). ZWC does not support transaction log based SQL backup because this mechanism is not supported either by MSDE or the SQL Server.
ZWC does not truncate transaction logs after a SQL database backup. If you wish to truncate transaction logs after a SQL backup, this can be accomplished using a post-backup plugin
The best backup plan is the one satisfies the Recovery Point Objective (RPO) and the Recovery Time Objective (RTO) that have been laid out by the business. Zmanda helps enterprises achieve RPO & RTO objectives - even during major IT outages. IT teams can expect seamless SQL backup and recovery processes across our entire product offerings. Zmanda MS SQL Agent provides the perfect, cost-effective solution for protecting all your Microsoft SQL databases and backup SQL database. IT Teams can quickly SQL backup or recover Microsoft SQL databases while the databases are still online. Zmanda ensures that resilience planning is simplified empowering IT teams while offering a cost-effective solution.
Amanda is designed to handle large numbers of clients and data, yet is reasonably simple to install and maintain. It scales well up and down, so small configurations, even a single client, are possible. There are many users who back up just a single client that is also the Amanda server. On the other hand, many Amanda users backup hundreds and even thousands of file systems (there could be multiple file systems per protected system) to a large tape library with multiple drives.
We currently support Microsoft SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. For more detailed list of the supported OS - please refer Compatibility Matrix.
To enable IT to test Zmanda on demo environments - we offer a fully licensed version of Zmanda for 14 days. Please fill out our Free Trial form, and our sales team will help you get started.
Ready to Get Started?
Developed by engineers passionate in making the best backup and recovery solutions.
1 million
servers under backup
Open Audits
Audits available through Amanda.
Coverity Rung 2 Certified
Homeland Security standard to certify products for Government use.