Post reply

Logshipping

  • August 7, 2003 at 8:25 am

    #160300

    Hi everyone,

    I have a little problem with logshipping.

    everything is working fine on my application server and files are transfered correctly to the backup server.

    But on this one, job that restore backup in the stand by database failled.

    The problem seems to be generated by the presence of files with a wrong sequence number.

    I recived error 14421 in application log of operating system, and looking in sql server I found error 22029.

    Is there someone who hace experienced the same problem?

    Thanks in advance

  • August 7, 2003 at 10:10 am

    #469031

    Have you tried restoring a full and then appling the transaction logs after. Perhaps a tranlog failed to get shipped.

  • August 13, 2003 at 5:19 pm

    #469828

    The best way from my experiences is that to include full backup plan in your logshipping schema.

    For example,

    From 3:00 Am to 11:00 Pm do logshipping.

    at 11:10 PM do full backup and restore the full back up on the standby server.

    In this way at least once a day, you can sync log file between primary server and secondary server.

    Anther means logshipping has an ability to correct its own problem.

Viewing 3 posts - 1 through 2 (of 2 total)

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