Evalution SQL Server 2008 R2

Question

0.00/5 (No votes)

See more:

I accidentally installed Evaluation Sql Server 2008 R2 instead of Sql server 2008 R2.
Now i am getting an error like Evaluation has expired. can anyone tell me how to retrieve my database's.

Posted 11-Jun-12 7:52am

lisalis

Add a Solution

2 solutions

Solution 1

Based on your question I assume you have a valid sql license.

The following article describes how to use your key to enable an evaluation version of sql.

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/b9140e57-ca4f-47d1-acc5-4f6db66e6ccb[^]

Posted 11-Jun-12 7:57am

Stephen Hewison

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pablo Aliskevicius · Accepted Answer · 2012-06-11T07:58:00

Solution 2

1. Using the 'Services' applet, stop SQL Server.
2. Save your MDF and LDF files (the ones for your databases, not MS).
3. Uninstall the evaluation version
4. Install SQL server
5. Attach the MDF/LDF files (from Management Studio, object browser, right-click the 'Databases' folder, pick 'All Tasks', then 'Attach Database').

Hope this helps,
Pablo.

Posted 11-Jun-12 7:58am

Pablo Aliskevicius

Comments

lisalis 11-Jun-12 16:07pm

I am getting an version error. i am not able to attache the databases.

Pablo Aliskevicius 12-Jun-12 3:04am

Possibly your evaluation version was more advanced that your production version: e.g., your evaluation version was SP1 or R2, and your production version is plain old sql2008.