Posted by Tom van Stiphout on 12/24/07 06:39

On Mon, 24 Dec 2007 01:37:57 GMT, "Neil" <nospam@nospam.net> wrote:

Check Database Properties > Files Page. It will show you how much the
db should grow once it fills up. 1MB by default, but you might have
changed it..

3GB is still very small, and hard disk space is cheap.

-Tom.



>Yikes! My database, which had been consistently 1 gig for a long time, went
>from being 1 gig to 3 gigs overnight! Looking at the nightly backups, the
>database increased on average about 5-15 MB per day, and was 1.06 GB on the
>Thursday night backup. Then, with the Friday night backup, it was 2.95 GB,
>and has stayed that way since!
>
>I did a Shrink on the database, but that didn't help the situation.
>
>The only thing I could think it might relate to is the following. I
>previously (about a week ago) changed a couple of tables' DateModified field
>from smalldatetime to datetime. (I posted about this under a separate thread
>here.) For some reason I was getting occasional errors which I believe might
>have been related to the new data type. So I decided to change the data
>types back to smalldatetime.
>
>I made the table changes Thursday night, right before the backup, but after
>the database optimizations. The backup Thursday night still shows the small
>database size. But the backup Friday night has the large size.
>
>So this might not be related to the table changes at all. But I know for a
>fact that there isn't 3x the data in the database. Somehow the database is
>bloated to 3x its size, and it's not from actual data.
>
>Any ideas about what I can do?
>
>Thanks!
>
>Neil
>

[Back to original message]