MS SQL doesn't show up in Backup Manager

Last Modified

Fri Apr 29 10:16 GMT 2022

Description

  • MS SQL doesn't show up in Backup Manager as an available datasource

Environment

  • Cove Data Protection

  • N-able RMM

    • Backup & Recovery
  • N-able N-central
    • N-able Backup
  • MS SQL 2005-2014 (with VSS writer for 2005 version)

Solution

  • Check if 'SQL VSS writer' is present among other writers in 'vssadmin list writers' output;
    • Open Command Prompt as administrator
    • Type: vssadmin list writers
  • Check if 'SQL Server VSS writer' service is present in services.msc and set to 'automatic' startup type;
  • Check if there are spaces in MS SQL databases names
  • Try to launch 'SQL Server VSS writer' service under .\Administrator (local administrator) account:
    1. ?Go to services.msc console and select SQL Server VSS writer service;
    2. Select Properties > Log-On tab and specify Administrator account credentials;
    3. Once done, restart below services from services.msc
      • ?Cryptographic Services
      • Volume Shadow Copy
      • Microsoft Software Shadow Copy Provider
      • SQL Server VSS writer
      • Backup Service Controller