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 UPDATEUS
AGE. 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 th
e
> database for unrestrict growth. But the free spaces so small, do I need t
o
> adjust it? If I do, I need it done in a hurry. Can someone provide
> sugestions? Thanks.
> --
> Gigi
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment