SQL Server Performance

re-applying old logs - dangerous?

Discussion in 'SQL Server Log Shipping' started by niall.porter, Sep 8, 2006.

  1. niall.porter New Member

    Hi all,

    Just a quick one for my first post - if I apply a transaction log backup which has already been applied to the database, will the transactions all get performed again or will SQL Server reject the duplicate transactions?

    Thanks in advance
    Niall
  2. satya Moderator

    Welcome to the forum!
    No it will not be applied as there will be a mismatch of LSN, if you want to know more about it then take your time to read SQL server books online which is installed alongwith your client tools ro server installation about Transaction log Architecture.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. niall.porter New Member

    Hi Satya,

    Thanks for the welcome and the speedy reply! I will do some reading when i get a chance, we've been having some problems with a non-MS log shipping solution so I needed to change it quickly.

    Cheers
    Niall
  4. satya Moderator

    No worries before placing a common question here it will help you to go thru books online.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page