Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

maximum database size of sql server 2005 express edition Expand / Collapse
Author
Message
Posted Monday, January 23, 2012 2:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 19, 2012 3:23 AM
Points: 1, Visits: 8
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
Post #1240029
Posted Monday, January 23, 2012 2:32 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 42,812, Visits: 35,931
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 2008, MVP
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

Post #1240043
Posted Monday, January 23, 2012 3:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 3:57 AM
Points: 91, Visits: 125

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
Post #1240055
Posted Monday, January 23, 2012 11:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 23, 2012 11:10 PM
Points: 1, Visits: 1
I think 4 GB will be very less. Will there be more upgrades to this?

Cloud Computing Cloud Consulting
Post #1240622
Posted Tuesday, January 24, 2012 5:13 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #1240765
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse