Post reply

log shipping process stopped?

  • January 5, 2013 at 3:16 am

    #272435

    Hi,

    Transaction log shipping process suddenly stopped due to as below errors

    BackupDiskFile::OpenMedia: Backup device '\\serverIP\d$\Foldername\ProdDB_20121227193101.trn' failed to open. Operating system error 2(The system cannot find the file specified.).

    thanks

    ananda

  • January 5, 2013 at 4:52 am

    #1574031

    OS error 2 means the specified file could not be found, was it purged or deleted maybe?

    What are your retention periods on the primary and secondary?

    To repair the LS scenario execute the following against the primary and secondary instances

    select DB_NAME(database_id), differential_base_lsn

    from sys.master_files

    where database_id = DB_ID('yourdb')

    and type <> 1

    group by DB_NAME(database_id), differential_base_lsn

    If the LSNs match, stop the LS jobs and take a differential backup of the primary. Apply the differential backup to the secondary then resume LS.

    If they don't match you'll need to reinitialise LS.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • January 5, 2013 at 5:22 am

    #1574033

    Yes, Mr. Perry you are right, TransactionLog file was deleted at secondary server...The last restored Tlog on 29-Dec-2012 at 4 AM, LS tried to apply next LSN but it was purged thru retention period... I had mention 3 days for File retention period....

    I am having Transaction Log 1-Jan-2013 upto till date, But these log are can't apply thru LS.

    I m going to reconfigure Log shipping process between two server again.

  • January 5, 2013 at 5:26 am

    #1574035

    did you run the query above?????

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • January 5, 2013 at 5:38 am

    #1574036

    removed existing LS before I got reply from you

    Before I have removed existing LS configuration at primary server after verify the LSN numbers...

    thanks

  • January 5, 2013 at 11:26 am

    #1574073

    most times a differential backup will do the job 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply