What happens when the 4 GB database size limit is reached?

psc161

Does the user get an error message

What error does an application get that tries to insert additional data via ODBC

Arnie Rowland


What error are you receiving

psc161

This was a hypothetical question. I haven't tried it out.

Do I really have to try it myself or does anybody already know the answer

Andrea Montanari

hi,

you get an exception..

Msg 1105:
"Could not allocate space for object 'dbo.t' in database 'ext' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup."

the message can be little misleading and probably something similar to error 1827
"CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of %I64d MB per %S_MSG." could probably be a better "indicator" of the real problem, but such an exception has not been defined..

regards

psc161

Thanks!

But the database will still be usable (readable) after this exception occured It doesn't become corrupted by that, I hope

Andrea Montanari

hi,

no, the database will stay available and not corrupted... you just will not be able to insert additional data...

regards

saint168

Is there way to find out the size of my database through T-SQL I would like to give my user a warning before the system blowup so they can purchase the full SQL Server.

Steve Herbert - MSFT

Try running

exec sp_databases

This will show you the databases on your server, as well as their size in kilobytes