How many databases can a SQL Server hold?

Question

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

How many databases can I put on a database server?

SQL Server Utility objectMaximum values for SQL Server (64-bit)Total number of instances of SQL Server per SQL Server Utility200User databases per SQL Server instance, including data-tier applications50Total number of user databases per SQL Server Utility1,000File groups per database1

Can SQL Server 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 tables can be created in a SQL Server database?

You can create up to 2,147,483,647 tables in a database, with up to 1024 columns in each table.

How many database connections can SQL Server handle?

By default, SQL Server allows a maximum of 32767 concurrent connections which is the maximum number of users that can simultaneously log in to the SQL server instance.

Expert · Answer