|
|
Posted by Erland Sommarskog on 08/28/05 20:52
time_to_go (camper_66@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, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|