Home Forums SQL Server 2008 SQL Server Newbies Can't restore transaction logs RE: Can't restore transaction logs
Ant-Green
SSC Guru
Points: 113445
More actions
November 12, 2012 at 2:16 am
#1558056
Sounds like the full backups last LSN is after the 11pm transaction log backup.
Check msdb.dbo.backupset correlating the first & last LSN columns to get the restore order.
But in this case it will be 10:30 Full, 12:00 TXLog