Hi,
I have a couple of DB's which have a lot of transactions against them overnight and the log files grow to hugh sizes, and I have to compact these files down several times a week. What is strange though is I have anoth DB, which as even more transactions against it and this db, doesn't have the problem.
Does anyone know how I can auto compact these files on a regular basis?
Thanks,
Gavin,
I have a couple of DB's which have a lot of transactions against them overnight and the log files grow to hugh sizes, and I have to compact these files down several times a week. What is strange though is I have anoth DB, which as even more transactions against it and this db, doesn't have the problem.
Does anyone know how I can auto compact these files on a regular basis?
Thanks,
Gavin,