• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2111
  • Last Modified:

Upgrade SQL Server 2005 from trial to full version

Hi, recently our SQL Server 2005 trial expired and we need to upgrade it to the full version.  We need ALL databases and everything to be 100% identical.  We have already purchased a licensed copy of 2005 server  and need to know how to upgrade.  None of the SQL services will start so I am not sure where to start on this.  Is there any way at all to upgrade the trial to full version without uninstalling and reinstalling?  Or if we have to, how do we keep everything 100% identical?  Thank you
0
OAC Technology
Asked:
OAC Technology
1 Solution
 
i2mentalCommented:
Just run it like a normal install and it should prompt the upgrade to full version.

http://blogs.msdn.com/sanchan/archive/2006/07/27/681086.aspx
0
 
OAC TechnologyProfessional NerdsAuthor Commented:
Unfortunately it's already expired and that won't work.  On the article you sent me to, it says that if I want to upgrade I have to uninstall the existing version and reinstall it.  " In case you want to keep the existing databases, you can use the SAVESYSDB parameter at command prompt."  What is the correct way to uninstall using the command line and keep all existing information?

Thank you
0
 
SteveSextCommented:
Hi, I am in the same position (inherited a trial sql server from the previous bozo) and urgently need to do this...what was the syntax with the savesysdb command to uninstall and reinstall SQL without losing data? I've tried SKUUPGRADE=1 but because teh services are already stopped, the isntall fails.

cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now