September 14, 2004 at 7:31 am
Does anyone have any links or resources on the internet they can point me to that can explain the use of the transaction log? Information I would like to know includes the purpose of the transaction log, the use of it, how to recover data from it, etc.
Any information would be greatly appreciated.
Michael
September 14, 2004 at 8:17 am
Read the BOL, it's your best source of information.
The transaction log keeps track of all transactions (trans). When a trans is stopped before completing, the log is used to rollback the trans. So, it keeps track of the status of transactions. You can use it to restore a database to a specific point in time. This is handy when someone does something they shouldn't and they know WHEN they did it.
Again, read the BOL for more information.
-SQLBill
BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply