Can I upgrade SQL 2008 on Windows SBS 2008 to SQL 2012

I have a Windows SBS2008 server, which now I've installed SQL 2012, has three versions of SQL; 2005, 2008 and 2012.
Is it possible to upgrade SQL2008 to SQL2012 so I just end up with two versions - 2005 and 2012 ?
I assume I have to leave 2005 alone as it's running SBSMONITORING



Yes you can.

Uninstall the SQL 2012, and then prepare for the migration.

This is a pretty good article. Reading the paper in step 1 will take you a while. http://blogs.extremeexperts.com/2012/05/17/upgrading-to-sql-server-2012/

I'm cuious why you are ugrading to 2012 and not 2014.



Yes you can.

Uninstall the SQL 2012, and then prepare for the migration.

This is a pretty good article. Reading the paper in step 1 will take you a while. http://blogs.extremeexperts.com/2012/05/17/upgrading-to-sql-server-2012/

I'm cuious why you are ugrading to 2012 and not 2014.



We only have a licenced copy of 2012



What about migrating the SQL Server 2008 databases into the SQL Server 2012 instance?



I'm trying to test my options on a VM. I've installed SBS 2008 SP1 and SQL 2008 but SQL 2012 won't install because it says it needs SBS 2008 SP2.
I've searched and searched on the Internet for SP2 but not found anything. Anyone know where I can find a copy? If I can get this installed then I can try all the options of upgrading, reinstalling etc. without destroying the live system.
The live system is Dell and it came with SBS 2008 SP2 but I can't use that copy for the test as it fails to install on non-Dell hardware (as you'd expect)



After much poking and prodding at the Windows Update option it has finally decided to download and install SP2 so I think my previous question has now been answered.
Hopefully after it has been installed, SQL 2012 will install and I can get back to the job in hand of working out the best way to consolidate the three versions of SQL.

Share this

Related Posts

There was an error in this gadget