regarding lsn

  • does taking tail log back up changes the lsn

  • Define 'change the lsn'

    What is the problem or reason behind this question?

    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
  • asked in interview friend...

  • To answer that needs more info about what the interviewer meant by 'change the LSN' (he could be referring to the tran log's current LSN or MinLSN, or any one of several LSNs that are recorded in the data file, or he could have meant something completely different)

    In the meantime, why don't you have a look in Books Online and see what a tail log backup does.

    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
  • A couple articles for you:

    Books Online: Tail-Log Backups (SQL Server 2012)

    A good, basic overview of the concept and why you would use it: Backing up the tail

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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