Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 20, 2016 3:49 AM
Points: 5,002, Visits: 4,797

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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 12:39 AM
Points: 8,227, Visits: 16,375
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 20, 2016 3:49 AM
Points: 5,002, Visits: 4,797
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, January 5, 2016 12:25 PM
Points: 111, Visits: 510
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 @ 9:12 AM
Points: 45,133, Visits: 43,236
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, MVP, M.Sc (Comp Sci)
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, January 5, 2016 12:25 PM
Points: 111, Visits: 510
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


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 19, 2015 6:21 AM
Points: 706, Visits: 328
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 12:39 AM
Points: 8,227, Visits: 16,375
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


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 19, 2015 6:21 AM
Points: 706, Visits: 328
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:25 PM
Points: 1,992, Visits: 11,547
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