Friday, September 3, 2010

HOW TO FIND THE LSN OF LAST TRANSACTION LOG SUCCESSFULLY RESTORED

SELECT top 5 *
FROM msdb.dbo.backupset
WHERE database_name = 'db_name'
ORDER BY backup_set_id desc

No comments: