Results 1 to 2 of 2

Thread: Transaction Log Question

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Dec 2008
    Posts
    103

    Transaction Log Question

    Can someone explain what is meant by 'Roll Forward' in the following description please ?. Does it mean that they are discarded or commited to the data file?

    When SQL Server is restarted, it looks for the most recent checkpoint in the transaction log and rolls forward all transactions that have occurred from that point forward since it is not guaranteed to have been written to the data file until a checkpoint is entered in the transaction log. This prevents transactions from being lost that were in the buffer but not yet written to the data file.

    Thanks.

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Transaction Log Question

    when you make changes to a database, the changes are not written directly to the database right away. They are cached into the transaction log. When SQL Server starts, it checks to see where it left off in the log, and then proceeds to commit the remaining transactions to the database. or rather, it verifies that the changes have been applied and if not, then applies them.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width