About SQL Server 2005 Editions

[ejanakieff]

We are going to acquire a license of the SQL Server 2005 and have doubts in relation to the type of license that we needed: Standard or Enterprise.

At the moment we have installed the SQL Server 2000 Enterprise, since we have the SQL Server installed in cluster of two nodes and in the Standard version of the SQL Server 2000 it was not including the support of cluster.

In the Standard version of the SQL Server 2005 that is included, therefore we do not know if this version is sufficient to us. We have a series of doubts, since in a Web of comparative of the different versions (

http://www.microsoft.com/spain/sql/productinfo/features/compare-features.mspx),

it indicates that in the standard version they are not including the following characteristics of high availability among others:

* Online Restore
* Online Indexing
* Fast recovery

We made backups and restorations of data bases online.
This would not be possible with the standard version?

Also we used “Full Text Catalogs” that is indexed automatically with the data base online.

I do not understand if these functionalities would not be supported by the Standard version of the SQL Server 2005.

Somebody could expose the main differences between the versions Standard and Enterprise of SQL Server 2005?

Thank you very much,
Eva Janakieff

 

[ptheriault]

Online Restore - Only matters if you have multiple file groups.

Online indexing - allows you to rebuild table indexes without locking users out of the table.

Fast Recovery - allows users to access the database during crash or mirroring failover.





- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

If you plan on doing an upgrade of the existing SQL 2000 Enterprise machine you will need to upgrade to SQL 2005 Enterprise. The SQL 2005 upgrade will not upgrade from SQL 2000 to SQL 2005 while downgrading the edition from Enterprise to Standard.

In addition to the online index rebuilding and online restore, you also have support for 3+ node clusters, the ability to use the lock pages in memory. You also get support for over 4 CPUs.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com