NetWorker: SQL Differential or Logs Only backup run as FULL when checkpoint restart is enabled

Summary: SQL Differential or Logs Only backup running as level FULL when checkpoint restart is enabled.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

A FULL backup occurs when running a SQL Differential or Logs-only backup,

Checkpoint restart is enabled in the client properties.
From the backup command we see the parameter -k 0 has been added.

Cause

NMM does not understand this parameter value. Checkpoint restart is for file system backups only.
NMM/SQL has a "checksum" option which adds -k, but not the 0 after like checkpoint restart does. 

This syntax issue prevents backup to run at the requested level, as this causes everything after -k to be seen as a database name: 
37812:nsrsqlsv: Database 0 does not exist.
37812:nsrsqlsv: Database -a does not exist.
37812:nsrsqlsv: Database device interface=data domain does not exist.
37812:nsrsqlsv: Database -a does not exist.
37812:nsrsqlsv: Database Data Domain interface=IP does not exist.
37812:nsrsqlsv: Database -b does not exist.
37812:nsrsqlsv: Database cosdd12prodsql does not exist.
37812:nsrsqlsv: Database -o does not exist.
37812:nsrsqlsv: Database REQUESTED_LEVEL:level=txnlog; does not exist.
37812:nsrsqlsv: Database -l does not exist.
37812:nsrsqlsv: Database full does not exist.

Resolution

Disable checkpoint restart under the client properties> general tab.

Disable checkpoint restart under the client properties> general tab.
 

Affected Products

NetWorker Module for Microsoft
Article Properties
Article Number: 000221410
Article Type: Solution
Last Modified: 23 Feb 2024
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.