Post reply

How to find LSN numbers in Log shipping

  • November 3, 2010 at 1:17 am

    #228590

    2.How to find LSN numbers in Log shipping

  • November 3, 2010 at 2:32 am

    #1245873

    Which LSNs? What are you trying to do/solve?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 3, 2010 at 8:25 am

    #1246023

    @ gail

    I think he trying to say, when log shipping is out of sync and we try to restore the transaction logs ,

    it gives error that the LSN number.....is too late to restore, try a earlier one.

    And at that time how can we know the LSN number of the transaction logs (which to be applied).

    Regards,

    Sushant

    Regards
    Sushant Kumar

  • November 3, 2010 at 8:49 am

    #1246046

    SKYBVI (11/3/2010)

    I think he trying to say, when log shipping is out of sync and we try to restore the transaction logs ,

    it gives error that the LSN number.....is too late to restore, try a earlier one.

    I'd prefer the OP clarify what he's asking than making guesses that could easily be wrong.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 4 (of 4 total)

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