|
-
Sep 18th, 2009, 10:35 AM
#1
Thread Starter
Lively Member
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.
-
Sep 18th, 2009, 11:16 AM
#2
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|