How many databases can I put on a database server?

Question

For SQL Server, the max number of databases you can have on a single SQL Server instance is 32,767.

Can a database server have multiple databases?

Database consolidation is the process of centralizing multiple databases and instances in order to share resources and thus, among other, cut licensing and hardware costs. There are three types of consolidation: Host multiple databases on a single SQL Server instance.

How many database can I create?

You can, I believe, create more than 256 databases per instance, but only 256 can be active at any point. If you try to activate more databases than you have configured for numdb, you will get: SQL1041N The maximum number of concurrent databases have already been started.

How many databases can be created in the single SQL Azure server?

Is there a limit on how many databases Azure Sql Server (PaaS) can have? About SQL Database servers per subscription, default limit is 6, the maximum limit is 150.

Can I use 2 databases?

You can use two databases the same reason most banks have two ATMs, for reliability. You can swap one in if the other fails, but to do it quickly requires setup, such as a cname and controlling your own DNS server.

Expert · Answer