DB space available 0.00Mb

Hi there,

I had originally set a max file size with restricted growth as we didn't think it would reach past it's limit. However, when I checked today it said space available 0.00Mb.

Two questions I have are:

(1) Would running out of space cause any problems to the database
(2) Can I simply just set this to unrestricted or set a higher limit and then the DB will continue to grow again?

Thanks

SUm, yes. And yes if you have space on the disk.|||(1) Would running out of space cause any problems to the database

This will always result in inserts/updates (and usually deletes) failing as there is no space available to push around the data.

Selects will usually continue to function normally.

Regards,

hmscott|||(1) Would running out of space cause any problems to the database

From BOL:

During recovery, it is a rare but possible occurrence for the server to require additional log or data space. If additional space is unavailable and either the log or data files cannot grow, the server:

1.Reports error message 9002 or 1105 in the Microsoft SQL Server error log.
2. Marks the database as suspect.
3.Takes the database offline.|||Have you tried first a :
DBCC UPDATEUSAGE ('mydb')
with mydb you database name ?

This reports and corrects inaccuracies in the sysindexes table, which may result in incorrect space usage reports by the sp_spaceused system stored procedure.