MCTS（70-431）学习笔记(原创)

第一章SQL Server 2005的安装

第一节 选择正确的数据库版本

[@more@]

MCTS（70-431）学习笔记

第一章SQL Server 2005的安装

第一节 选择正确的数据库版本

一、课程总结

■ SQL Server 2005分为五个版本: 企业版、开发版、标准版、工作组版以及快速版。SQL Server 2005 includes five editions: Enterprise Edition, Developer Edition, Standard Edition, Workgroup Edition, and Express Edition.

■ 企业版对所有的特性及功能都没有限制。Enterprise Edition has no limitations and contains all features and functionality.

■ 开发版对所有的特性及功能都没有限制，但是不可以用以生产环境。Developer Edition has no limitations and contains all features and functionality, but it is not licensed for production.

■ 标准版具有针对较大数据集的特性及功能，但是它所支持的聚集节点的数量，还有使用系统资源、在线索引、索引视图、快速恢复、在线还原和数据分区的能力都是受限制的。Standard Edition has features and functionality suited for larger data sets, but it is limited in the number of nodes it supports for clustering as well as in its capability to use system resources, online indexing, indexed views, fast recovery, online restores, and data partitioning.

■ 工作组版不具备需要操作大数据库的特性和功能，而且在支持中型和大型企业的能力是受限制的。Workgroup Edition does not include the features and functionality needed to operate large databases and is restricted in its capability to support mid-size and large companies.

■ 快速版对于那些免费的分布式小型的应用安装数据库是很有用的。它不适合于企业级的数据库。Express Edition is useful for small application-installed databases that need to be distributed free of charge. It is not suited for organization-wide databases.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9650775/viewspace-937967/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9650775/viewspace-937967/