I'm testing my disaster recovery process and have a question about the Recovery Point of SQL Server databases.
My database instances use the Ola Hallengren scripts to run backups calling Quest LiteSpeed. In production we have full backups every night with transaction log backups every 15 minutes during the day. These backups are stored in H:\MSSQLBACKUPS. The H: drive is then backed up by the Commvault backup system every hour throughout the day. In addition, once a day we back up the VMware virtual server.
In a disaster, we do the following:
1) Use Commvault to restore the VMware SQL virtual host
2) Use Commvault to restore the most recent .BAK and .TRN backup files on H:
3) Use Quest Litespeed to restore databases.
Because of the delays involved between Quest LiteSpeed and Commvault, the question came up: Exactly what is our recovery point? I can see the date stamp on the most recent .TRN (database transaction log backup) file. Is that what I should report as the Recovery Point? Is there a more accurate number to report?
Any help is appreciated.
Ken