Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Upgrade SQL Server 2012 from 2008 R2 Expand / Collapse
Author
Message
Posted Friday, August 30, 2013 8:50 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 4,235, Visits: 4,282

I have a new Server with Windows Server 2012 installed.

I'm going to install SQL Server 2012 Enterprise Edition.

I have some SQL Server 2008 R2 Databases which I want upgrade to 2012.

Can I upgrade without installing 2008 R2 on the new Server?

If I take the backup and perform a restore what else do I need to do to in addition to setting the compatibility mode?

Any input would be greatly appreciated.



For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1490192
Posted Friday, August 30, 2013 8:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 6,351, Visits: 13,680
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1490194
Posted Friday, August 30, 2013 9:12 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 4,235, Visits: 4,282
Perry Whittle (8/30/2013)
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.


Thanks.

That is what I did when I upgraded database to 2005 & 2008.



For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1490202
Posted Friday, August 30, 2013 9:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
Perry Whittle (8/30/2013)
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.


Hi Perry

a quick doubt

Can we use Export import tool to do this job
Post #1490207
Posted Friday, August 30, 2013 9:24 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:15 PM
Points: 43,017, Visits: 36,179
You could, but why would you want to? Restoring a backup's going to be faster and less work.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1490209
Posted Friday, August 30, 2013 9:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
GilaMonster (8/30/2013)
You could, but why would you want to? Restoring a backup's going to be faster and less work.


Just want to know....

thanks

i am still a Rookie
Post #1490210
Posted Monday, September 2, 2013 3:56 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
Perry Whittle (8/30/2013)
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

In case it gets necessary: You can't restore a 2012 database back to 2008 even if you don't change the compatibility level.
Post #1490569
Posted Monday, September 2, 2013 5:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:57 PM
Points: 6,351, Visits: 13,680
SQL Surfer '66 (9/2/2013)
Perry Whittle (8/30/2013)
just restore the 2008 R2 database to the 2012 instance and the database engine will upgrade the database for you.

In case it gets necessary: You can't restore a 2012 database back to 2008 even if you don't change the compatibility level.

No!!!
Really!!!


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1490590
Posted Monday, September 2, 2013 7:38 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
Why the sarcasm? I learned this myself the hard way once. Hopefully others can avoid it.
Post #1490624
Posted Monday, September 2, 2013 11:07 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 773, Visits: 4,972
Good to know, because I almost did that. (See, some of us are still noobs making admittedly dumb mistakes...)
Post #1490667
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse