Post reply

Transaction logfiles skipped

  • March 5, 2009 at 8:59 am

    #135263

    Hi

    Before logshipping jobs there was a maintenance plan for log backup, so we stopped that and transfered the files manualy. After setup logshipping the trn files where copied automaticly to the secondary server, but the restore job skippes the files. Should logshipping be setup just after the full backup? How to make sure the secondary db(in non-recovery mode) has the same state as the primary?

    Thanks for help

    Jan

  • March 5, 2009 at 11:34 am

    #954244

    What does your job history tell you?

    I would guess that you are missing a log backup between the .trn files you have and your last full backup - you need all of them to get the logshipping up and running.

    Meredith

  • March 5, 2009 at 2:54 pm

    #954463

    I have all the files, but they are produced by two different log backup jobs after each other. The history say 'skipped' also on the first log backup after the full backup.

  • March 5, 2009 at 3:53 pm

    #954512

    Is the job history telling you that an earlier log file must be applied or that a more recent log file must be applied?

    knowing that will tell you what step to take next.

    the history will look like this:

    21:15:01 - Transaction log file E:\LogShipTo\TBG_20090302190001.trn was skipped. More recent transaction log file must be applied to database.

    or this:

    12:20:02 - Transaction log file E:\LogShipTo\TBG_20090303070000.trn cannot be applied to database. More earlier transaction log file can be applied.

    the bolded selections are the pertinant details.

    Meredith

  • March 8, 2009 at 3:49 pm

    #955728

    There where entries like that. After restoring a new fullbackup the logshipping job restores the files correct.

    Another point is the failover. With a scipt(http://support.microsoft.com/kb/246133/en-us) the logins can be transfered. What about the user assignment. Are they assigned when the logins are applied or must that be done manualy?

  • March 9, 2009 at 1:57 pm

    #956378

    If you applied the script before database restoration then they will get mapped automatically.

    MJ

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

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