About SQL Server

[Wen Lie]

Dear All...

I've one problem...

I have a database at SQL Server... And as we know, that every transaction to the database will recorded into log file...

My question is..
if the log file is already too large... how can I delete it ?? I mean.. how can I make it small again...???

Thx...a lot...

Wille
Junior VB Programmer

[tbostrup]

If you have a database administrator, discuss the problem with her. If not, read up on backup strategies and log maintenance. There are a few options including various TRUNCATE LOG options for the log, but it also depends on your database backup strategy.

If the Truncate Log On Checkpoint flag is set for your database, only uncommitted transactions take up space in the log.

HTH,
Tore.