How to find the Recovery Point

Question

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

nodier garcia · Answer

Hello Ken, the answer will depend on the point of view. If you are looking into it in the SQL Server instance point of view, the recovery point will always be the last transaction log created. 
 If you are looking from the sever standpoint, the recovery point will be the last H backup done by Commvault. 
 
 Hope this helped.

nodier garcia · Answer

You can query the msdb to verify the last backup performed for an specific database using the following query SELECT /* Columns for retrieving information */
 -- CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS SRVNAME, 
 msdb.dbo.backupset.database_name,
 msdb.dbo.backupset.backup_start_date,
 msdb.dbo.backupset.backup_finish_date,
 -- msdb.dbo.backupset.expiration_date, 

 CASE msdb.dbo.backupset.type
 WHEN 'D' THEN 'Full'
 WHEN 'I' THEN 'Diff'
 WHEN 'L' THEN 'Log'
 END AS backup_type,
 -- msdb.dbo.backupset.backup_size / 1024 / 1024 as [backup_size MB], 
 msdb.dbo.backupmediafamily.logical_device_name,
 msdb.dbo.backupmediafamily.physical_device_name,
 -- msdb.dbo.backupset.name AS backupset_name,
 -- msdb.dbo.backupset.description,
 msdb.dbo.backupset.is_copy_only,
 msdb.dbo.backupset.is_snapshot,
 msdb.dbo.backupset.checkpoint_lsn,
 msdb.dbo.backupset.database_backup_lsn,
 msdb.dbo.backupset.differential_base_lsn,
 msdb.dbo.backupset.first_lsn,
 msdb.dbo.backupset.fork_point_lsn,
 msdb.dbo.backupset.last_lsn
FROM msdb.dbo.backupmediafamily
 INNER JOIN msdb.dbo.backupset
 ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id 

 /* ----------------------------------------------------------------------------
 Generic WHERE statement to simplify selection of more WHEREs 
 -------------------------------------------------------------------------------*/
WHERE 
 msdb.dbo.backupset.database_name = 'YOURDATABASE'
Order by 
msdb.dbo.backupset.backup_finish_date