1

Looking for a straight forward answer from the SQL guru's

To make a decision on which license to purchase, we were looking for the number of databases supported by a server instance of each edition (Express, Web, Standard, Enterprise) but couldn't find any useful information on the net. Any help is appreciated.

Improve this question
1
  • @ughai so this is not limited by the edition? Commented Jun 9, 2015 at 4:41

2 Answers 2

Reset to default
3

Technical answer: 32,767

Practical answer: much harder and more variables

There is no difference between editions, but performance features as the editions go up can enable your machine to practically support more dbs.

Source: https://msdn.microsoft.com/en-us/ms143432.aspx

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

@ahsan - Yes, that is correct, but express limits your hardware so that no matter the machine size, only 1 CPU core and up to 1 GB of RAM is used.
1

there are four editions mainly (Express, Web, Standard, Enterprise),it support upto 524PB size except express edition(which is support 10GB).first create one database and see the size of that based on that calculate the no.of databases that particular edition support it.:) for more:https://msdn.microsoft.com/en-us/ms143432.aspx

Improve this answer

3 Comments

Your link clearly says, maximum number of databases per instance is 32,767. Max number of databases does not have anything to do with max database size.
ya but,,,when you are going to maintain large companies data it may be consider!!!
In general, possibly, but that is not what the OP asked for.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.