June 2, 2004 at 9:24 am
In general tab of db properties Database size is 14515mb, space available is 0mb.
Status is Normal. In data files tab space allocated is 14514mb for primary filegroup.
file properties are set to automatically grow in 1000 megabytes, and restrict file growth to 20000mb.
Should I increase the size of the space available in the data files tab, and if so why does the status say normal?
June 2, 2004 at 12:03 pm
First: Data file size will NOT be the same as Database size. Data file is just that - the data itself. Database size is the size of the data file(s), the log file, any indexes.....etc.
Second: Your database is set to grow. That's good. However, it's set to stop at 20000mb. You are at 14515 mb, so your database can only grow 5485 more mb. But not really....it can really only grow 5000 more mb. Why? You have the growth set for 1000 mb. So it will add 1000 mb to become 15515, then 1000 to become 16515, then 1000 to become 17515...etc. Eventually it reaches 19515 (give or take a couple of mb) and can't grow anymore. Why not...19515 + 1000 = 20515, 515 mb OVER the 20000 limit.
To answer your questions, don't change the size of the database files...they will change automatically (due to the autogrowth of 1000mb). Is that a good amount? Only you can tell. How big are your transactions on the database?
Lastly, your database is NORMAL. It's not suspect, corrupt or anything else.
-SQLBill
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply