Microsoft SQL Server Express 2005 Limits

Hi,

Could someone please tell me if there is a maximum amount of install instances of Microsoft SQL Server Express that can be installed onto a server?

Also, I understand that each database can not exceed 4GB, but is there a maximum amount of databases?

Thanks
spen_langAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Detailed documentation here:

http://www.julian-kuiters.id.au/article.php/sqlserver2005-express-limitations

>>  if there is a maximum amount of install instances of Microsoft SQL Server Express that can be installed onto a server?

You can have several instances and that depends upon your hardware limitations of CPU and RAM

>> but is there a maximum amount of databases

No, depends upon the load your server ie., 1 CPU, 1 GB RAM supports
0
 
spen_langAuthor Commented:
Thanks for your prompt reply, much appreciated. Liking the website too.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
0
All Courses

From novice to tech pro — start learning today.