August 30, 2013 at 8:50 am
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/
August 30, 2013 at 8:57 am
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"
August 30, 2013 at 9:12 am
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/
August 30, 2013 at 9:18 am
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
August 30, 2013 at 9:24 am
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
August 30, 2013 at 9:26 am
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 :hehe:
September 2, 2013 at 3:56 am
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.
September 2, 2013 at 5:35 am
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"
September 2, 2013 at 7:38 am
Why the sarcasm? I learned this myself the hard way once. Hopefully others can avoid it.
September 2, 2013 at 11:07 am
Good to know, because I almost did that. (See, some of us are still noobs making admittedly dumb mistakes...)
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy