Home Forums SQL Server 2008 SQL Server 2008 High Availability All the 3 jobs are running successfully but Restoration in Secondary server is not happening RE: All the 3 jobs are running successfully but Restoration in Secondary server is not happening

  • 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

    • logs are not being copied, hence no restore
    • logs are being copied, but a log backup is missing, so no restores will take place

    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" 😉