maximum database size of sql server 2005 express edition

Question

maximum database size of sql server 2005 express edition

inna.reddy 71060

SSC Veteran

Points: 235
More actions
January 23, 2012 at 2:04 am

#255333

Hi,
What is the maximum database size of sql server 2005 express edition?
if the maximum size of the database size is 4GB(mdf file is filled with 4GB), if we create ndf fill , shall the database size can be increased?
Regards,
Inna

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

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

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

4GB. That's the maximum size of the data files of the database, not the maximum size of one of the data files of the database, so the total size of the mdf and all ndf files can't exceed 4GB.

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

padhis SSCommitted Points: 1762 More actions · Answer 2

Sql server 2008 R2 express edition thhe database size limitation has been increased to 10GB

http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx

parkerhains Valued Member Points: 57 More actions · Answer 3

I think 4 GB will be very less. Will there be more upgrades to this?

Cloud Computing[/url] Cloud Consulting[/url]

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 4

parkerhains (1/23/2012)
I think 4 GB will be very less. Will there be more upgrades to this?

Either spam or really bad worded.

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.