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
-
Log on to the CommServe computer. Ensure that the login user account has administrative privileges.
-
Open the Microsoft SQL Server Management Studio.
-
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, '')