Sunday, March 25, 2012

database free spaces

I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
This is what I see it in the view taskpad of the database. I did setup the
database for unrestrict growth. But the free spaces so small, do I need to
adjust it? If I do, I need it done in a hurry. Can someone provide
sugestions? Thanks.
--
GigiFist, the report might be based on old information. Read up on DBCC UPDATEUSAGE. And to increase the
file size, you use ALTER DATABASE ... MODIFY FILE... Or, use EM to specify a size larger than the
current size.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Gigi" <gigi@.discussions.mcirosoft.com> wrote in message
news:45B66CA4-FE21-4019-88EF-C9E3507C47EB@.microsoft.com...
>I have a database total size 2710 MB. It is 2699 MB used and 11 MB free.
> This is what I see it in the view taskpad of the database. I did setup the
> database for unrestrict growth. But the free spaces so small, do I need to
> adjust it? If I do, I need it done in a hurry. Can someone provide
> sugestions? Thanks.
> --
> Gigi

No comments:

Post a Comment