Posted by Dylan Parry on 02/19/07 16:59

Greg D. Moore (Strider) wrote:

> Ok, 4.5 GB database is trivial.

:)

> You mention 400 MB not including indexing. How much are indexes taking?

Adding them up manually, it appears to be around 100-200MB.

> Also, if you're not doing transaction log backups, or aren't in simple
> recovery mode, much of that could be your log file.

Yes. A bit of investigation showed me that the log files were just over
4GB in size. I trawled the web looking for information on how to get
this size down, and I've managed to get it back to a sensible size.

Looking at my other reply, it would seem sensible to change the way that
logs are handled, as you suggested.

--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk

Programming, n: A pastime similar to banging one's head
against a wall, but with fewer opportunities for reward.

[Back to original message]