MS SQL Server - Re: Database growing unexpectedly

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Database growing unexpectedly

Gurba

2006-03-05, 8:24 pm

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in news:#noh#6kPGHA.1532
@TK2MSFTNGP12.phx.gbl:

> Try running DBCC UPDATEUSAGE(0) and report back the space used.
>

Hi,

seems the first output from
USE MyDb; EXEC sp_MSforeachtable 'EXEC sp_spaceused [?]'

was missing some tables...

I ran UpdateUsage and the sp_spaceused again and found the reason for the
growth.

Case closed :-)

Thanks,

Sponsored Links