Loading...

Verifying the Backup Status of Virtual Machines Using a SQL Query

You can run a SQL query on the CommServe database to verify the status of backups performed for each virtual machine in the last n days. This query can be run periodically to verify that scheduled backups are completing as expected.

Procedure

  1. Log on to the CommServe computer. Ensure that the login user account has administrative privileges.
  2. Open the Microsoft SQL Server Management Studio.
  3. To verify the status of backups performed for each virtual machine in the last n days, run the following query on the CommServe database:

    select * from VMProtectionCoverage (n, 'backup_type')

    Where n is the number of days and backup_type is the type of backup (FULL, INCREMENTAL, DIFFERENTIAL, or SYNTHETIC FULL).

The query is run for all virtual machines protected by any Virtual Server Agent within the CommCell system.

Result

When you run the query to verify backups performed for virtual machines, the status for each VM will be one of the following:

Status

Description

Currently Protected

All backups for the virtual machine were successful in the last n days.

Discovered, Not Protected

The virtual machine is discovered but was never backed up.

Manually Excluded

The virtual machine is excluded from the subclient and was not backed up in the last n days.

Not Protected in the time range

No backup was performed for the virtual machine in the last n days, but a backup was performed in the past.

Example: SQL Query for Incremental Backups

To verify the status of incremental backups performed for all virtual machines protected in the last 30 days, run the following query:

select * from VMProtectionCoverage (30, 'INCREMENTAL')

Example: SQL Query for All Backup Types

To verify the status for all types of backups in the last 30 days:

select * from VMProtectionCoverage (30, '')

Last modified: 1/7/2019 4:55:50 PM