Post reply

what commit does?

  • August 12, 2004 at 9:36 pm

    #164702

    I'm new in mssql db and want to understand more. when  I issue a commit statement after the insert, will the record straightaway copy to the database file(MDF)? or still in the log file and depend on the check point to bring it over to database file.

     

  • August 13, 2004 at 7:47 am

    #518867

    will be written to the log, then written as a change in memory and flushed out. However, if you are worried about some hardware issue, if the server crashed between the log write and the flush, on recovery, it would be written to the mdf.

  • August 13, 2004 at 10:43 pm

    #518994

    so that's why we have to implement Full or Bulk-Logged Recovery option so we can backup the log file, since some of the changes are still in the log file.

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

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