How many databases can you have on one server?

How many databases can a server have?

SQL Server Database Engine objectMaximum values for SQL Server (64-bit)Databases per instance of SQL Server32,767Filegroups per database32,767Filegroups per database for memory-optimized data1Files per database32,767

Can a server have multiple databases?

There are three types of consolidation: Host multiple databases on a single SQL Server instance. Host multiple SQL Server instances on a single machine. Host multiple virtual SQL Server machines on a single physical machine.

Can a 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.

Can you have multiple databases?

Good reasons to create separate databases would be to support different availability requirements or simplify administration. For example if your databases require very different backup schedules or different recovery models. Another reason would be if you may want to run them on different instances.