March 4, 2004 at 10:16 am
Hi,
I need to know if it's possible to create more than 50 instances on a Windows 2000 Server ?
Each instance are very little (less than 1Go, normally 600Mo).
Can soem one help me out on this
Pascal
March 4, 2004 at 12:59 pm
SQL 2k will support a max of 16 instances on one machine. The number of databases on one instance is a different question. Your limitations there are disk space and memory.
You might want to pickup a book named: "SQL Server 2000 Fast Answers for DBAs and Developers" by Joseph Sack. It is a pretty good quick reference.
March 6, 2004 at 6:43 am
Recommend BOL too - http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en
------------
Ray Higdon MCSE, MCDBA, CCNA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply