Jagadeesh Chowdary (4/16/2014)
Hi Sir,Can please Elaborate the above Step.
I have observed that restore job is not running and showing the following error message but when i checked that all the transaction getting Restored even though...
Message
2014-04-16 13:00:00.64Could not find a log backup file that could be applied to secondary database 'TestDB'.
PFA...
Check each steps history, either
You have an LSN gap probably, this can be bridged by locating and restoring all log backups or, if no full backup has occurred against the Primary, apply a differential backup.
To check if the Primaries differential base LSN is in sync with the Secondary run the following against the Priamry and Secondary instances and return the results
select name, differential_base_lsn from sys.master_files
where database_id = db_id('logshipped_db_name') and type_desc = 'rows'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉