SQL Server Log file

[kcwallace]

I have a SQL Server 2000 database that has a log file that is entirely too big. The file has grown to be 12 Gb. I tried to shrink it using the Shrink wizard where it says that it only needs 230 Mb. However, after the wizard runs the file remains the same size.

The database is backed up nightly.

How do I reduce its footprint, and prevent it from growing so big?

 

[PlausiblyDamp]

How are you backing up the SQL Database? Are you using the builtin support (either directly or via a 3rd party) or just backing up the physical files?

If you are using the built in routines then it should be truncated on a sucessful full backup / log backup. You can always clear it by doing a

BACKUP LOG <db name> WITH NO_LOG

and then try to shrink it again.

 

[kcwallace]

Thank you very much.

I am using builtin routines.

I did what you suggested and it did the trick. Thank you