Is Microsoft SQL Server 2008 R2 Evaluation a standard or enterprise version

Posted on 2011-10-14
Last Modified: 2012-05-12
Can anyone tell if the evaluation is a SQL standard or enterprise?  Does it have 180 days trial period
Question by:tommym121
    LVL 17

    Accepted Solution

    Evaluation software from Microsoft generally has "the best" features built in - and it is true for SQL Server 2008 R2 Evaluation.  It is enterprise.  All features will work for 180 days (6 months) and then they will cease to work thereafter.

    You can unfortunately not license the product to make it a purchased Standard or Enterprise version - you will need to install a new SQL Server and migrate the databases from the evaluation one.  Do not let it expire if you wish to do this.
    LVL 8

    Assisted Solution

    According to the wikipedia article, the eval version has the features of the Enterprise edition.

    However, I have also heard that it is possible to access a trial version even of the datacenter version (which is built on the enterprise edition).  

    Also, various versions may be available via MSDN beyond what is available to the general public.  

    If it is already installed, your best bet is to try one of the approaches described in this document in order to see exactly what is installed.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now