MSSQL Plug-in

The MSSQL plug-in allows backing up and restoring databases of Microsoft SQL Servers. The plug-in allows working with SQL Server located on local computer only. Its work relies on the following Windows services:

  • SQL Writer Service (always installed as a part of an SQL Server)
  • Volume Shadow Copy Service

Snapshots of databases are made without interrupting the server’s work (Volume Shadow Copy Service provides recoverability of backups). To restore a database, the plug-in stops the respective SQL instance, then copies the files, and then re-launches it.

Supported Versions

You can use the MSSQL plug-in to back up and restore all versions of Microsoft SQL Server 2005, 2008 and 2012. Note that for 32-bit and 64-bit versions of Windows Server, you need to use 32-bit and 64-bit version of Handy Backup, respectively.

Privileges

To use the MSSQL plug-in, Workstation must have enough privileges to make API calls to SQL Writer Service and Volume Shadow Copy Service.

Plug-in File System

The file system provided by the plug-in is organized as follows:

  • Folders correspond to SQL Servers and carry the respective names. They have no attributes.
  • Files correspond to databases available on the selected SQL Server, and carry the respective names. They have no attributes.

Since the plug-in’s files and folders have no attributes, during comparison with files that are already backed up, they will be always considered as different. This means that incremental backup (backing up of new and changed files) won’t work: for effective versioning, use differential backup.

Format of Backup Files

As a result of backup, you will have files that are named similarly to databases. Each file is basically a ZIP archive with all data files and transaction logs of the respective database.

Backing Up

The MSSQL plug-in can only be used as a source of data for backup tasks. To learn more, please refer to Specify Backup Set.

Adding the MSSQL plug-in to backup set

To add an SQL database to backup set, follow these steps:

  1. In the Data Sources pane, select MSSQL, and then click Add. The Select data... dialog opens.
Selecting data of the MSSQL plug-in
  1. Check the boxes next to files (i.e. databases) that you want to back up.
  2. When finished the selection, click OK. Selected data appears in the Backup Set pane of the New Task Wizard.

Restoring

When the plug-in restores databases, it queries the SQL Writer Service to identify paths of the respective files. If new paths don’t correspond to the ones in backup files, restoration will be performed to the new paths. This means that if you want, you can restore databases to a different place.

  1. Open New Task Wizard.
  2. Select Restore task, and then click Next.
  3. Browse for the index file (backup.hbi) located in the destination folder. Select it, and then click Next.
  4. In the Select Restore Locations dialog, verify the details of restoration.
Selecting restore locations for backups made with the MSSQL plug-in

If you want to restore a database to a different place, follow these steps:

  1. 4.1. In the Select Restore Locations dialog, select a database (file of the MSSQL plug-in file system), and then click Change Location. The Change restore location dialog opens.
Changing restore locations for the MSSQL plug-in
  1. 4.2. Select a new path for the database, and then click OK.

After verifying paths of restoration, you need to select type of restoration, enter decryption password (optional), and name the task. These steps are not specific to the MySQL plug-in. To learn more, please see Restore Task.

When you run the restoration, the plug-in firstly stops the respective SQL instance and all Windows services that depend on it. Then it copies the files to their original locations, and re-launches the services.

In this section:

Contact Us

support@handybackup.net

sales@handybackup.net

+1 (707) 703-13-11

Essentials

Installing Standalone Version

Installing Server Version

Installing Workstation

Workstation Configuration

Registration

Quick Start

User Manual in PDF, version 7.1.2 (5.3 MB)

User Manual in PDF, version 6 (3 MB)

User Manual for v.6 (old version)

User Manual in PDF, version 7

Who uses our backup software?