Chowdary's (7/11/2014)
Hi All,T.log can not be restored on the secondary Database which is due to that transaction log sequence is broken.in that time what we will check & do .
Please give me some suggestions.
Regards
Jagadeesh...
Have you taken a full backup at the source since the LS broke, if not then a differential backup and restore to the LS secondary will kick the LS plan back into sync
Check the differential base LSN on primary and secondary using
select DB_NAME(database_id), differential_base_lsn
from sys.master_files
where database_id = DB_ID('your primary\secondary LS db')
and type_desc = 'rows'
group by database_id, differential_base_lsn
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉