Databases out of space, but not really

Question

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Carl Federl One Orange Chip Points: 25384 More actions · Answer 1

Space information is not maintained in real-time but only when indicies are rebuild or "dbcc updateusage" is run.

"dbcc updateusage" can be also be invoked by running:

exec sp_spaceused @updateusage = 'true'

SQL = Scarcely Qualifies as a Language

ShekharNaidu SSCrazy Points: 2092 More actions · Answer 2

have u checked the growth settings..

whether the Maximum filegrowth is set to

1.Restrticted grow

2.Unlimited growth

Thanks ,

Shekhar

AndrewM-375946 Right there with Babe Points: 777 More actions · Answer 3

remember the transaction log may grow when indexs are being rebuilt

SQLBill SSC Guru Points: 51440 More actions · Answer 4

I have seen this also and used the solution Carl suggests. Just run DBCC UPDATEUSAGE ('dbname')

-SQLBill

Sam Greene SSCertifiable Points: 5252 More actions · Answer 5

Thanks Carl and Bill - sounds like that is the solution.

Sam Greene SSCertifiable Points: 5252 More actions · Answer 6

Will sp_msforeachdb @command1='dbcc updateusage (''?'')' cause log growth?