Backing up MSSQL Simple and Fast: Handy Backup FAQ

MSSQL Backup is a module of Handy Backup™ that helps you to back up and recover MS SQL data. It provides hot backup of MS SQL databases including tables, structures and other data, fully automating this process.

You can find basic information about backing up Microsoft SQL Server database in these FAQ:


Which editions of Handy Backup contain the MSSQL Backup feature?

This feature is available as the standard option for server editions of Handy Backup:

For other editions of Handy Backup, you can purchase MS SQL Backup option as a separate feature, using the plug-in purchasing page.


Version 7.8.8, built on 15 March, 2017
65.8 MB


Which versions of Windows are supporting MSSQL backup?

Handy Backup is designed for Windows Server 2012(R2)/2008(R2)/2003 and Windows 10/8/7/Vista/XP backup and recovery. The MSSQL Backup feature is proved to work correctly under both 32- and 64-bit platforms.



Which versions of Microsoft SQL Server can be backed up with Handy Backup?

The software can save data from the most actual MS SQL 2012, as well as back up MSSQL 2008, back up MS SQL 2005, MSSQL 2000 and other versions.



How does backing up MS SQL affect the operational status 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.



Can I use the generic Database feature to back up MS SQL server?

Sure. However, yuu must install an appropriate ODBC driver for your MS SQL Server instance, and some native functions of MS SQL backup can be unavailable or significantly slower with a generic Database feature instead of dedicated MS SQL backup tool.



Does Handy Backup put a heavy load on an operating system?

Our backup program is completely resources-friendly; it occupies only a very little space on your hard drive and consumes only a smallest amount of RAM, compared to other MSSQL backup software.



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;
  • Local HDDs, SSDs or externally-plugged USB hard disks or pen drives;
  • Remote FTP/SFTP/FTPS backup servers;
  • Local Area Network drives, ncluding network-attached storages (NASes);
  • Online Backup cloud services, including Amazon S3, Dropbox, Google Drive and other;
  • Dedicated Handy Backup online storage called HBdrive.


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 a need to launch backup tasks manually for every time?

No, the backup can be flexibly scheduled. Handy Backup’s scheduler lets you automatic SQL backup 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, 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 for commercial or business purposes?

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 have no restrictions about the goal of implementation (except, of course, any illegal activity).



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 purchasing it?

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.


Version 7.8.8, built on 15 March, 2017
65.8 MB

See Also:

SQLite backup

0 comments

    Contact Us

    support@handybackup.net

    sales@handybackup.net

    See Also

    Website backup - most reliable solution to protect your business web representation

    MySQL backup - simple, comprehensive backup of the MySQL database tables

    Backup to FTP - transfer your backups to remote FTP server for more data security

    Sharepoint backup - access Sharepoint server-level data using the “MSSQL” plug-in

    Who uses our backup software?