Easy MSSQL Backup: FAQ
MS SQL is popular and widely used Database Management System (DBMS) developed by Microsoft. MSSQL Backup is a module of Handy Backup™ that helps you to back up and recover MS SQL data. You can find the information on backing up Microsoft SQL Server database in the FAQ below:
Is MSSQL Backup a standalone program?
No, it is just one of the functions supported by Handy Backup. MS SQL backup can be performed with two plug-ins:
- Database Backup plug-in lets you back up database tables via ODBC connectivity. It is not system-specific and can be used for most database management systems.
- MSSQL Backup plug-in lets you back up SQL Server completely, with all stored procedures, indexes, views, and other data (not only tables).
Under what systems can I perform MSSQL backup?
Handy Backup is designed for Windows Server 2008/2003/2000 and Windows 7/Vista/XP/2000 backup and recovery. The MSSQL Backup and Database Backup are proved to work correctly under both 32- and 64-bit platforms.
What versions of Microsoft SQL can Handy Backup work with?
The software can back up MSSQL 2008, back up MS SQL 2005, MSSQL 2000 and other versions.
Download all-included backup and disaster recovery software for Windows! See Handy Backup download details...
The Database Backup plug-in is included into Professional edition, and MSSQL Backup plug-in is included into Full edition of the program.
- Handy Backup Home Professional. Buy for $99
- Handy Backup Small Server. Buy for $199
See other purchase options
How does backing up MS SQL affect the operation of MSSQL server?
MS SQL Server database can be backed up and restored in both active and inactive server modes. All database-related functions of Handy Backup support hot backup technology which enables you to copy the data without stopping the server.
Does Handy Backup put a heavy load on an operating system?
Our backup program is famous for its resource-friendliness: it occupies very little space on your hard drive and consumes the least RAM, as compared to other MS SQL backup software.
What is included into SQL server backups made by the utility?
The Database Backup plug-in enables you to back up all tables of the database, or any specific tables of your choice. The MSSQL Backup plug-in backs up Microsoft SQL Server entirely.
Where the backed up MSSQL data can be stored?
Handy Backup can save your data to virtually any type of storage media and servers, including:
- CD, DVD, Blu-Ray, HD DVD and other local backup media
- Remote FTP backup servers
- Local Area Network drives
- External Firewire or USB hard/flash drives
- Online Backup services, and much more...
Can the MSSQL data be compressed and/or encrypted?
Yes, your backup can be ZIP-compressed and ciphered with a reliable 128-bit Blowfish algorithm.
Do I have to launch backup tasks every time manually?
No, the backup can be flexibly scheduled. Handy Backup’s scheduler lets you back up SQL automatically by setting a convenient schedule and have backups run daily, weekly, or on whatever time period you like.
Is it difficult to set up and use your utility for MSSQL backup?
No, all modules of Handy Backup program share the same simple Explorer-like graphical user interface. Smart Setup Wizard and online help will guide you through all steps of installing the program, creating and managing backup tasks.
What about updates?
Our backup tool is constantly evolving (see News for details), we introduce new features every 2-3 months and constantly revise existing features, to keep in step with the developing technologies. Besides that, we can provide any kind of customization of our backup solution, to meet the needs of our corporate clients. We can even add new features by your request!
Can Handy Backup be used in commerce?
Yes, Handy Backup can be used for both home backup and business backup. The license grants you the right to use the program on only one computer, but the environment is not important.
Do you have a technical support team?
Yes, we provide free unlimited support for all registered users, by e-mail, phone and Skype. Our corporate customers are always the top priority, so you will receive all possible assistance from us using our software.
Can I try Handy Backup before buy?
Yes, Handy Backup is distributed as a shareware, and comes with a 30-days trial period during which you can try all features of the program without limitations.
To learn more about Handy Backup and its useful functions, refer to backup features of our software...
This feature is available in Handy Backup Small Server:
$199 per license
What to Back Up
My Documents backup - one click backup of the My documents folder including pics, videos, music, text files
Website backup - most reliable solution to protect your business web representation
Disk Image Backup - back up your hard drive by creating a hard drive image and saving it to the storage medium
MySQL backup - simple, comprehensive backup of the MySQL database tables
ODBC Database Backup - back up any ODBC compatible databases including MySQL, Oracle, FoxPro, Interbase, MSSQL, DB2, MS Access, Postgre SQL etc.
Where to Back Up
Backup to DVD-R - record your backups to DVD-R with our in-built DVD burning tool
Backup to CD-R - record your backups to CD-R using data encryption and compression with one click
Backup USB - back up your data to any USB connected device such as USB flash key
Backup to FTP - transfer your backups to remote FTP server for more data security
Backup from FTP - back up data stored on a remote FTP server to your local computer or any removable storage medium
How to Back Up
Backup with ZIP compression - backup with 10 levels of Zip compression saves storage space
DVD backup verification - makes sure your data are restorable from DVD copy you made
Synchronizing files and folders - one click synchronization of files and folders across multiple locations including remote FTP servers
Who uses Handy Backup?
