Microsoft SQL databases

To offer an enhanced solution, standalone Cove Data Protection (Cove) has replaced Backup & Recovery. Where Backup & Recovery has been enabled and continues to be so for devices, the options presented here are still available.

Where Backup & Recovery options are not present on your N-sight RMM dashboard, this means you will now need to use Cove.

To start a 30-day free trial of Cove, click the app switcher in the Product bar, and 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