maximum no of databases on sql servr | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

maximum no of databases on sql servr

What is the maximum no of databases which can be created on a db server.What will happen if this exceed.?
Is a big number. But that big number (don’t remember right now) is about objects. That include: databases, tables, triggers, sp, etc.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
32,767 check all the other limitations
So, maximum possible databases (theoretically) in a server are 524,272.
(16 instances * 32,767 databases)
[8D] /* SKChandra */
This is a mere theoretical number. In practise you won’t get anywhere near this number. Some systems are more than busy with one single db.
And if you get to exceed this number, I suspect you’ll receive an error just stating that. —
Frank Kalis
SQL Server MVP

True and for fun you can calculate the numbers. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.