x

SQL Server 2008 to 2008 R2 Upgradation

Hi, Is it possible to upgrade SQL Server 2008 Enterprise Evaluation to Sql Server 2008R2 Express Edition.

more ▼

asked Aug 15, 2013 at 07:30 AM in Default

avatar image

skbarik
208 22 22 29

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

That sounds like a downgrade but still an upgrade, and it also sounds like something I would consider not doing even if it was supported.

Edit I tried to upgrade SQL 2008 Standard to SQL 2008 R2 Express and got the following error:

FeatureUpgradeMatrixCheck - Checks whether the specified feature meets SQL Server 2008 R2 upgrade requirements. The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 R2 version and edition upgrade matrix in Books Online.

Edit

If you are going in production with this, I would uninstall first:

  • Take a backup of your databases.

  • Script out all logins, jobs and other objects that you need.

  • Script out all backup and maintenance jobs.

  • Uninstall Evaluation Edition.

  • Install Express Edition.

  • Restore backups.

  • Restore logins and other objects.

  • Create a task in windows that runs your backups/maintance scripts via sqlcmd (or do powershell if you prefer that.

  • Sleep with no worries.

more ▼

answered Aug 15, 2013 at 09:23 AM

avatar image

raadee
4.5k 12 18 22

With all that going on, I would recommend doing a side-by-side, rather than in-place. Makes it easier to pick up on something you've forgotten...

Aug 15, 2013 at 10:03 AM ThomasRushton ♦♦

agreed, uninstalling before the other server is in place leaves you with no escape route if the new server installation goes wrong. I would leave step 4 - Uninstall Evaluation Edition. until the very last, if I did it at all. It wont hurt being on the server and stopped.

Aug 15, 2013 at 10:18 AM Fatherjack ♦♦

I had side by side in my head when I edited the post, forgot it! Thanks.

Aug 15, 2013 at 11:10 AM raadee
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2188
x780
x89

asked: Aug 15, 2013 at 07:30 AM

Seen: 1609 times

Last Updated: Aug 15, 2013 at 11:10 AM

Copyright 2017 Redgate Software. Privacy Policy