Post reply

Data till transaction is commited

  • March 9, 2004 at 6:54 am

    #110645

    Hi All,

    II have a question on Transaction commit/rollback.

    Question

    My understanding is that untill a transaction is comitted, the modifications(inserts/updates/deleted) are not made on th disk ( datafiles).

    For Example if i am doing a bulk copy of millions of records from a flat file on to sql server table, untill all the records are bulkcopied and transaction completes successfully and a commit is issued explicitly and the data is NOT wriiten to disk, where is the data stored (FOR THAT TRANSACTION)till then?

    I mean where is the data stored till the transaction is completed and committed ? This could be really a large data can cache may not b ebig enough to hold this amount of data..?

    Please let me know

    Thanks,

    THNQdigital

  • March 9, 2004 at 7:07 am

    #497959

    That data IS written to disk. It goes to the Transaction Log. When you commit it is moved to the database file (at checkpoint time) when you roll it back is freed in the Transaction log.

    HTH

     


    * Noel

  • March 9, 2004 at 7:37 am

    #497966

    Please see my answer here

    Well, not mine, but Kalen Delaney's.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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