Post reply

SQL express how many databases of 10 GB of space

  • June 20, 2013 at 1:51 pm

    #294955

    Hi I'm just trying to find out how many databases can I create on SQL server 2012 Express edition

    I know that the maximun size is 10GB of storage per database but how many databases can support.

    Also regarding reporting services what is the biggest limititaion?

    Thanks

    APA

  • June 20, 2013 at 2:10 pm

    #1626107

    the theoretical limit is 32767, but i think it has more to do with disk space and memory capacity.

    http://msdn.microsoft.com/en-us/library/ms143432.aspx#Engine

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 20, 2013 at 2:25 pm

    #1626113

    Thanks for the prompt response

    Have you used the sql reporting services on the SQL express edition? What is the most critical limitation?

    Thanks

  • June 20, 2013 at 2:40 pm

    #1626119

    Does this help you?

    http://msdn.microsoft.com/en-us/library/cc645993.aspx#Reporting

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

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

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