HUGE Log Files - Help?!?
I've got a client who is running about 5 database on SQL Server 2000.
The databases are about 25 - 100 megs each.
The log files in some cases are huge.
In one case the log file is 68 GIGS.
Rebooting, backing up, shrinking the log file doesn't help.
Why are they so huge? Is there a setting that may be causing this?
More importantly, how can I shrink them?
Can I just delete them in SQL Server (Enterprise Manager?)
I see where it lets me but I don't know the consequences.