terryw-sec
asked on
SQL 2008 standard versus enterprise
We are looking to upgrade a SQL 2000 database version 8.00.2039. It currently has 20 databases. Is there a set limit on how many databases you can have between standard and enterprise? I heard that standard will only allow up to 15 dbs and enterprise will hold up to 50 dbs. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't believe there's a database count limit in either standard or enterprise. The differences are in the advanced features, like Clustering and Online index defragmentation. As stpm11 mentioned above, Microsoft has a detailed feature comparison:
http://download.microsoft.com/download/2/D/F/2DF66C0C-FFF2-4F2E-B739-BF4581CEE533/SQLServer2008EnterpriseandStandardFeature%20Compare.pdf
That lays out all the differences, feature by feature.
http://download.microsoft.com/download/2/D/F/2DF66C0C-FFF2-4F2E-B739-BF4581CEE533/SQLServer2008EnterpriseandStandardFeature%20Compare.pdf
That lays out all the differences, feature by feature.
ASKER
Thanks for all of your help.
http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx
I was pretty sure there wasn't a database limit, but rather a users, or processor limit.