locked
ldf RRS feed

  • Question

  • hi all,


    may i know ldf recorded uncommited transactions or not

    Monday, July 15, 2013 6:04 AM

Answers

  • Understanding Logging and Recovery in SQL Server
    http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
    A SQL Server DBA myth a day: (15/30) checkpoint only writes pages from committed transactions
    http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1530-checkpoint-only-writes-pages-from-committed-transactions/

    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Marked as answer by Fanny Liu Tuesday, July 23, 2013 7:58 AM
    Monday, July 15, 2013 6:23 AM
  • hi all

    may i know ldf recorded uncommited transactions or not

    Article provided by Rama is best for u..plz go through it

    In short Ldf has uncommited transactions and this keeps ocurring as transaction keep coming.When database recovers from crash recovery all uncommited transactions will be rolled back and comitted will be rolled forward so as to bring DB in consistent state (following ACID property)


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by Fanny Liu Tuesday, July 23, 2013 7:58 AM
    Monday, July 15, 2013 7:00 AM

All replies