August 17, 2004 at 2:31 am
hy everybody,
I have a 12 gb database. It is configured to automaticaly grow in blocks of 250 MB.
The avaible space at the E.M. DB is 0.0 MB. but the HD free space is 13GB.
I've tryed to check the DB wiht the CHECKDATABASE command and all was right.
I've also forced the DB size to 13 GB.
Doing that the avaible space contiunes to 0.0 MB but the allocated space shows 1 GB avaible.
After that I can work for a time until a srink operation is made, which send me to the original situation.
August 17, 2004 at 6:55 am
The value shown for Space Available in EM is unreliable. Try increasing the size of the database and then running:
EXEC sp_spaceused @updateusage = 'TRUE'
It also sounds as though you may have the Autoshrink option set to True. I'd switch it off if I were you.
Sean
August 19, 2004 at 11:44 pm
It works!
Thanks.
Best regards
Marc
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply