MS SQL Backup With Handy Backup

Handy Backup provides a fast and effective way to backup MSSQL Server which is a widely used database management system designed by Microsoft. Since a lot of the today’s business activities exploit databases stored on SQL servers, the question of how to backup MSSQL database is of much importance for enterprises of all sizes.

To backup MS SQL database with Handy Backup your user account must satisfy two conditions. Firstly, you must have administrator privileges in MS SQL, and secondly, you must use Windows Authentication Mode for your connections to SQL Server.

• Accuracy and reliability of MSSQL backup. Unlike many other backup tools that use the ODBC protocol to backup MSSQL database, Handy Backup exploits Microsoft API which allows you to backup MS SQL database with all views, indexes, stored procedures, and other data. This type of MS SQL backup can’t be performed over the network, but provides much more accuracy.
• Backup MSSQL databases without stopping the service. You can perform MSSQL backup with Handy Backup without interrupting your SQL server services.
• Support for backup MS SQL Server 2005, MSSQL 2000, MS SQL 2008. To back up MS SQL databases you only need to add “MS SQL” item to your backup set, and Handy Backup will automatically detect all SQL server databases on your computer and display them for selection.
• Backup options and scheduling. Handy Backup has a number of advanced backup options which allow you to compress your MSSQL backup with an integrated ZIP-compressor with 10 levels, encrypt it with 128-bit blowfish encryption, store backup with timestamps, etc. Besides this, you may schedule MS SQL backup task to be repeated daily, weekly, monthly, or with your own period of time. For a full list of features, refer to Handy Backup features.
• Versatile choice of backup storage media. Your MS SQL backup can be stored on any kind of storage media: Handy Backup supports backup to DVD, backup to external drives (backup to FireWire, backup to USB and other), remote backup service, and other backup destinations.

Handy Backup is a perfect tool for MSSQL backup: it allows you to always feel safe about your data and guarantees that in case of whatever disaster you will be able to restore your databases quickly and error free.

Read FAQ about MSSQL databases backup via ODBC protocol with Handy Backup.