Printable View
I am not a DBA and I run a personal web site that has gotten pretty large. I have never done anything to maintain my sql server, and now my transaction log is 10 Gigs and my data is only like 300 Megs. I am starting to get a memory leak with the sql service. What should I do? Is it bad to have a huge transaction log. I am not familiar with any of this stuff, so someone please point me in the right direction.
change your recovery model to simple.
do a checkpoint on that database and shrink the log file.
u can also do a sp_detach and sp_attach database.
OOPS. its sql server 7.0.
u have to do a sp_detach on the database. (Database will be unavailbale for a min)
delete the log file. (.ldf)
then sp_attach_db (.mdf) on the database.
You should backup log regularly or just set db option 'truncate log on checkpoint'.