By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,652 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,652 IT Pros & Developers. It's quick & easy.

Database file size question please

P: n/a
Hi,

I have set the DB to auto grow by 30 %. As well I have set it to
unrestricted size.... However , I see the available size continually being
reduced to now less then .54 MB... Why is there not enough available ?
G
Aug 28 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
time_to_go (ca*******@hotmail.com) writes:
I have set the DB to auto grow by 30 %. As well I have set it to
unrestricted size.... However , I see the available size continually being
reduced to now less then .54 MB... Why is there not enough available ?


Where do you see thie available size?

Auto-grow does not set in, until there are no free extents at all, and a
new extent is needed.

Note that if there is no free disk space for these 30%, auto-grow will
fail.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Aug 28 '05 #2

P: n/a
Hi,

I see the available space in the general tab > space allocation. it shows
used as 35.5 MB and availble .53. I have checked disk space available and
it is sufficient.
r,
g
"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...
time_to_go (ca*******@hotmail.com) writes:
I have set the DB to auto grow by 30 %. As well I have set it to
unrestricted size.... However , I see the available size continually being reduced to now less then .54 MB... Why is there not enough available
?
Where do you see thie available size?

Auto-grow does not set in, until there are no free extents at all, and a
new extent is needed.

Note that if there is no free disk space for these 30%, auto-grow will
fail.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Aug 28 '05 #3

P: n/a
time_to_go (ca*******@hotmail.com) writes:
I see the available space in the general tab > space allocation. it shows
used as 35.5 MB and availble .53. I have checked disk space available and
it is sufficient.


Have you experienced any errors which claims that you are out of space?

Also, try running DBCC UPDATEUSAGE and then sp_spaceused in Query Analyzer.
Enterprise Manager is not always trustable for size information.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Aug 28 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.