Create database - MaxSize Reached

Question

Create database - MaxSize Reached

jeelanik

SSC Eights!

Points: 953
More actions
September 17, 2010 at 1:29 pm

#224177

Hello,
Just curious what happends when the data size of database reached MaxSize? Does the database become corrupt/read only mode/crash the server/crash the tempdb?
Thank you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

No corruption, no crashes. A simple error saying that there's not enough free space when you go to insert data.

Do note that, for other than Express, the max size of a SQL database is over 500 000 TB, so I don't think you'll need to worry about it in most cases.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 2

Express allows 10GB. You can test it there. It will just stop you from adding more data

JeremyE SSCoach Points: 16121 More actions · Answer 3

If the database fills the primary data files to the max file size you have set for them, the following error message will be written in the SQL log and server application log.

Could not allocate a new page for database 'DATABASE' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.