Posted by Neil on 12/24/07 07:40

"Neil" <nospam@nospam.net> wrote in message
news:V3Ebj.22$L22.18@newssvr11.news.prodigy.net...
> 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
>


Here's one thought I had: is it possible to look at a breakdown of the
objects in the database, and how much space each one is taking up? Perhaps
that would help to determine what's going on here.

[Back to original message]