[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Upgrading SQL Server 2008 180-day Evaluation to *STANDARD*

Posted on 2009-07-10
3
Medium Priority
?
1,667 Views
Last Modified: 2012-05-07
Hi,

I noticed that the 180-day Evaluation version of SQL Server 2008 is the
Enterprise version .

Is there a *STANDARD* evaluation version that I can download?  If not,
is there going to be any problem "upgrading" the Evaluation Enterprise
version to a *STANDARD* version (and how much additional stuff is going to be
left inactive on my disk and, more importantly, in my registry, etc. if I do
so)?

Regards,
Rajesh
0
Comment
Question by:rajeshmarappan
  • 2
3 Comments
 
LVL 52

Expert Comment

by:Mark Wills
ID: 24825285
You can upgrade your eval version to standard :  http://msdn.microsoft.com/en-us/library/ms143393.aspx  scroll down and look on the left for the Eval version...


And to do the upgrade, use the commandline setup specifying ACTION=editionupgrade : http://msdn.microsoft.com/en-us/library/ms144259.aspx
0
 
LVL 43

Expert Comment

by:pcelba
ID: 24825346
Standard evaluation version does not exist. I would recommend Developer version having all features of Enterprise for about $50 (not for production use).

The "inactive" stuff exists, of course. Don't ask how much because nobody knows... To be sure you've uninstalled everything you would need to create the disk partition copy and restore it instead of SQL Server uninstallation.
0
 
LVL 52

Accepted Solution

by:
Mark Wills earned 750 total points
ID: 24825585
Oh, forgot about that "inactive stuff".

There are differences but in all reality the engines are the same, so, really should not have to worry about "inactive stuff" in terms of affecting your machine and installed programs. The difference is more like a list of extensions support by the same programs, so it is more like turning on or off various settings.

More important is if you have used any of the Enterprise features in your database when you do go to upgrade.

Have a look at : http://www.microsoft.com/sqlserver/2008/en/us/compare-std-ent.aspx there is a PDF link under the very brief table showing major areas. There is a more detailed table in Books On Line : http://msdn.microsoft.com/en-us/library/cc645993.aspx

And before you do upgrade, make very sure you have used the SQL Server backup function to take a full SQL backup of your databases so you can recover them if needed, then remove any of the Enterprise only functions that you may have used, and backup again... The last one is what you need to "restore" into the standard version if needed.

You can always run a registry cleaner afterwards if you are so inclined...

0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

607 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