How many databases can a SQL instance have?

Question

Connections per client

Can a SQL instance have multiple databases?

A SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 Standard or Enterprise Edition instance may be used to run multiple databases, including a mix of third-party and/or Blackbaud databases. However, performance will degrade as more databases are added to the same instance.

How many databases can be created on an instance?

Multiple MySQL databases or SQL Server databases (up to 30) or Oracle database schemas can be created on a given DB Instance.

How many database can be created in SQL Server?

A maximum of 32,767 databases can be specified on an instance of SQL Server.

Expert · Answer