Post reply

Administration

  • February 10, 2010 at 2:00 am

    #138739

    How can we see the LSN of a file ?

  • February 10, 2010 at 5:07 am

    #1116706

    Don't understand your question. LSN stands for Log Sequence Number, it's a binary value that each and every change in a DB has. Files don't have LSNs, transactions do.

    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

  • February 10, 2010 at 6:20 am

    #1116743

    When you restore db or log, you can see First LSN and Last LSN columns. Am not sure if you are asking about the same or not. You can also execute 'Restore headeronly..' command to view the same.

  • February 10, 2010 at 8:09 am

    #1116849

    How can we see the LSN's ?

  • February 10, 2010 at 8:17 am

    #1116858

    Why? They identify log records. What's your interest in seeing them?

    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

  • February 10, 2010 at 10:20 pm

    #1117362

    Please let us know what exactly you want to do. So that we will be able to help you out.

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

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