Large Log file

[RobColborne]

On SQL server 2000 I have a 30 gb log file on a 3 gb database. I need to shrink this down to a resonable amount. I have tried the shrink database option from Enterprise Manager but the size of the file did not change.

How can I reduce the size of this file?

I will only be doing complete database back-ups.

Thanks in advance

Rob

 

[tlbroadbent]

A frequently asked question! See faq183-345 and thread183-107365.

Additional resources:

http://msdn.microsoft.com/library/en-us/architec/8_ar_da2_7vaf.asp

http://msdn.microsoft.com/library/en-us/tsqlref/ts_dbcc_3pd1.asp

http://msdn.microsoft.com/library/en-us/tsqlref/ts_dbcc_8b51.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[volodja]

This is the best way
Truncate log without backup
You can see this in Books online (backup)

BACKUP LOG pubs
WITH
TRUNCATE_ONLY
I spend so much time to find solution. Please try!
Volodja@serbiancafe.com