Recommended database version?
jweather Posts: 320
In your experience, is SQL Server 2005 Express Edition sufficient for hosting RMS? Is there some upper limit to the number of rooms that can be supported on Express Edition? The cost for Standard Edition can be rolled into our proposal if it's necessary or useful, but I don't see any reason to enrich Microsoft if we don't need to. Thanks.
SQL Express is recommended for installations of 50 rooms or less although there is no reason that it will not scale higher. Typically SQL Server is used in instances where there are existing SQL databases, redundancy or backup requirements.