Which SQL Server edition to choose
Currently we are using SQL Server 2000 Enterprise Edition. The size of the da开发者_如何学Ctabase is less than one GB and it's not heavily used. We want to upgrade it to SQL Server 2008. Which Edition (Standard/Enterprise) would be suitable for this upgrade? The OS we'll use is Windows Server 2008.
Please advise.
Thanks,
Imran
You might want to consider the Express Edition. It has a 4GB limit (I think) and is free. If you database is not heavily used, this might work for you.
Any edition will be suitable from Express up to Enterprise for this.
The question is what features do you require from Enterprise that are not available in Express.
For example, what level of High Availability do you need?
精彩评论