Discussion Locked

SQL Server Database limits

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How many databases can be attached to an SQL Server? Is it dependent on machine memory etc?

3 replies

by steved

For SQL Server 7.0, the maximum is 32,767 databases on a server. Memory should not be a consideration, though it certainly is important in terms of handling simultaneous connections and activity. Most servers will probably run out of disk space longbefore they have 32,767 non-trivial databases.

I hope this helps.

Steve Diamond

This discussion is closed to new replies.