Posted by Simon Hayes on 09/28/05 12:40

I don't really understand your first question, but the log is there to
ensure that all changes to the database can be rolled back/forward if
necessary, such as when the server crashes. See "Transaction Logs" in
Books Online. As for shrinking it, see here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;272318&Product=sql2k

If you don't need transaction log backups (see "Selecting a Recovery
Model" in BOL), then the simplest option may be to set your database to
the simple recovery model - the log will then be truncated
automatically.

Simon

[Back to original message]