Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but confuse with enterprise and standard edition.

share|improve this question

closed as not constructive by Mark Storey-Smith, Max Vernon, Aaron Bertrand, dezso, Mat Apr 14 '13 at 10:56

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 4 down vote accepted

The 180 day evaluation version from Microsoft is Enterprise Edition. AFAIK there is no ability to "trial" Standard edition from Microsoft outside of a licensing agreement you might have.

From the point of view of overhead between editions, there's negligible difference.

If you want something longer than 180 days, get the developer edition as its feature complete compared to Enterprise but only $50 from Amazon

share|improve this answer

SQL Server Editions
SQL Server 2008 is available in the following editions:

  1. Enterprise Designed for the largest organizations and those needing to leverage the full power of the SQL Server 2008 platform.
  2. Standard Designed for small and midsized organizations that do not need all the capabilities available in SQL Server 2008 Enterprise.
  3. Workgroup Suitable for small departmental projects with a limited set of features.
  4. Express A freely redistributable version of SQL Server that is designed to handle the needs of embedded applications as well as the basic data storage needs for server-based applications, such as Web applications with a small number of users.
  5. Compact Designed as an embedded database.
  6. Developer Designed for use by developers in creating SQL Server applications. SQL Server 2008 Developer has all the features and capabilities as SQL Server 2008 Enterprise, except that it is not allowed to be used in a production environment.
  7. Evaluation Designed to allow organizations to evaluate SQL Server 2008. SQL Server 2008 Evaluation has all the features and capabilities as SQL Server 2008 Enterprise, except that it is not allowed to be used in a production environment and it expires after 180 days.

hardware engine support1 engine support2
Reference: Microsoft SQL Server Implementation and Maintenance (Exam 70-432)

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.