Microsoft SQL databases

Standalone Cove Data Protection (Cove) has replaced Backup and Recovery. If Backup and Recovery is enabled for your devices, the options shown here are still available.

If Backup and Recovery options do not appear in N-sight RMM, use Cove instead.

To start a 30-day free trial of Cove:

  1. Open the app switcher in the Product Bar.
  2. Select Cove Data Protection (Cove).

When installed, the Backup Manager automatically detects if the device is running Microsoft SQL Server, and automatically adds it as a selectable Data Source.

Refer to MS SQL topic for information on MS SQL pre-requisites

To backup MS SQL database (VSS):

  1. Open the Backup Manager
  2. Navigate to the Backup tab
  3. Click Add against MS SQL
  4. Expand the MS SQL database (VSS) node to select the SQL Server and databases(s) to backup

    5. It may be necessary to click the MS SQL name to display the node structure

  5. Configure the MS SQL database (VSS) Schedule
  6. Amend the Backup & Recovery Check to take account of the increased backup jobs

To amend the selected data sources:

  1. Open the Backup Manager
  2. Go to the Backup tab
  3. Click Edit
  4. Expand the node and change the selection

Copy-Only Mode for Microsoft SQL Server Backup

It is possible to perform a backup of a Microsoft SQL Server in copy-only mode.

This mode performs a full backup without updating the internal backup history for SQL Server. This method of backup does not act as a base backup for further differential backup operations and also does not disturb the history of the previous differential backups.

IMPORTANT: Database Administrators should fully understand the recovery implications of using different SQL backup modes before enabling this mode

To enable copy-only mode:

  1. Login to the target device
  2. Go to the Backup Manager installation folder (default: C:\Program Files\Backup Manager),
  3. Locate and (as Administrator) edit config.ini
  4. Add the below section and string

    5. [MsSql]

    UseCopyOnlySnapshot=1

  5. From the services console (Start > Run > services.msc) restart the Backup Service Controller service