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
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.