MS SQL Server 2008 Express 8GB Size Limit

Posted on 2011-05-09
Last Modified: 2012-05-11
I have heard that MS SQL Server 2008 Express has a size limit of 8 GB.  Does this mean that a single database cannot grow larger than 8 GB?  Or does this mean that all of the databases on the one machine cannot grow larger than 8 GB?  In other words, could I have 5 databases that are 6 GB each on the same machine?

Question by:StumpedAndGrateful
    LVL 32

    Accepted Solution


    The limit is 10GB and it means a single database can be larger than 10GB
    So you could have 10 databases each 9GB in size
    LVL 32

    Expert Comment

    Sorry, can not be larger than 10GB
    LVL 32

    Expert Comment

    And thats sql server 2008R2 to be precise

    All other versions of sql server express have a limit of 5GB
    LVL 29

    Expert Comment

    by:Paul Jackson

    Author Closing Comment

    Thanks!  That was quick & exactly what I was looking for!

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Forgotton SQL Server 2008 SA Password 13 24
    SQL Question 9 34
    Help with SQL 9 62
    How to copu batch file to a network location 62 47
         When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now