Click here to Skip to main content
15,503,367 members
Please Sign up or sign in to vote.
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

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[^]
 
Share this answer
 
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.
 
Share this answer
 
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.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900