Description

How to determine the last backup date for an Enterprise Vault database

Issue

To validate or confirm the information being displayed in critical alerts regarding database backups, the following steps can be taken.

- Launch SQL Management Studio and select the Enterprise Vault instance

- Expand msdb - Tables - System Tables - dbo.backupset

- Right click dbo.backupset and Select Top 1000 Rows

- Within the table you can locate the Database Name, User_Name responsible for the backup, Backup Start Date and Backup Finish Date

- Enterprise Vault uses a stored procedure called GetDaysSinceDatabaseBackup to query the msdb - dbo.backupset table