Posted by Hugo Kornelis on 09/25/07 11:45

On 20 Apr 2006 13:11:20 -0700, Jack wrote:

>So I gathered... So now I ask this question to the empty universe:
>Why the heck does SQL Server maintain a transaction log and all the
>headaches which go along with it if it can't even be read or used
>without 3rd party tools?!?

Hi Jack,

Of the top of my head:

1. To roll back a change if you DID remember to put a BEGIN TRAN first,
2. To restore a database after an unexpected shutdown,
3. To allow point in time restore,
4. For log shipping.

I've probably forgotten a few as well :-)

--
Hugo Kornelis, SQL Server MVP

[Back to original message]