Avatar of futureman0
futureman0 asked on

Moving SQL 2008 R2 to 2012 on same server for SCCM 2012

As the title states I need to move my existing database from SQL 2008 R2 to SQL 2012 due to a licensing issue. The database is running SCCM 2012 SP1. What happened is that I installed the standard trial version of 2008 R2 with 180 day expiration, but as it turned out I should have installed the enterprise version. I'm flat out not able to purchase a serial number to upgrade the trial to full version to due the Microsoft agreement with my institution.

Very straight forward setup. One server with SCCM 2012 (SP1) currently using SQL 2008 R2 for the backend on the same server. I need to uninstall SQL 2008 R2 and do a clean install of SQL 2012. I absolutely do not want to start over with my SCCM 2012 installation as everything is working as it should. I need to migrate over the existing database to a new install of 2012.

What would be the recommended course of action be?

I've never done much with SQL, but I would think it would be reasonable to assume I would export the existing database, note all of the users accounts the SCCM uses, import the database to server SQL 2012 server and make sure all the user accounts are the same. Anything you think SCCM with give me problems with doing this?
Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft Server Apps

Avatar of undefined
Last Comment

8/22/2022 - Mon

You can take a full backup of your databases and go with an in place database upgrade.
David Todd

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

So while trying to do a in place upgrade from 2008 R2 to 2012 I got the following error:

Checks whether the specified feature meets SQL Server 2012 upgrade requirements.

The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2012 version and edition upgrade in Books Online.

The instance of SQL i'm trying to update is 10.52.4000 running as an evaluation. For whatever reason I have also SQL 2012 Express instance ADK still installed as well. Not really sure what 2012 Express is doing there, and I can't seem to uninstall it.

Any idea what is going to prevent the upgrade? Perhaps going from 2008R2 Evaluation to 2012 SP1 Enterprise isn't allowed?

Any ideas what is going on?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes