Upgrading SQL Server 2008R2 to SQL Server 2012 in 5 minutes
Link to downloadables i.e. SSMS 2012 and Express databases
https://www.microsoft.com/en-us/download/details.aspx?id=29062
Official list if potential issues during an upgrade
http://technet.microsoft.com/en-us/library/ms143179(v=SQL.110).aspx
http://msdn.microsoft.com/en-us/library/ms143179.aspx
You may also want to check the discontinued features page:
http://technet.microsoft.com/en-us/library/ms144262
Run the Upgrade Advisor before you upgrade
http://technet.microsoft.com/en-us/library/ms144256.aspx
windows server 2012
in the Upgrade rules window "sql server 2012 feature upgrade failed " . How to fix it ?
hi, what will be process if both server are in cluster,,,,,? with database runing in production environment…
Hi Bryan I tried but getting this error 'rule "sql server 2008 r2 service pack 1 or later is required for upgrade. " failed'
In an OS and SQL upgrade scenario, would you upgrade SQL first or the OS first…2008 to 2012?
Hey, friend. Not bad style. You should take it easy. You look done in. Guess you must be the four-door fist champion. Charlie Wei?
Upgrade ruels sql server 2012 feature upgrade failed . How to fix it ?
Great share brother! I found one helpful article to upgrade SQL Server to higher version. Here is the link:
https://www.cybrary.it/0p3n/best-way-copy-sql-server-database-one-server-another/
Hello Bryan, great tutorial. Do you have any experience with upgrading SQL with log shipping?
Hi Bryan, nice video, appreciate the post. We need to updgrade Sql2008R2 to SQL 2012.However, one of my products needs to retain the 2008 DB. Can i upgrade SQL to 2012 while keeping specific DBs at 2008? Hope this make sense, Thanks in advance.
i want to upgrade our database system from 2008 to 2014 is there any critical points i should take care of it.
Thanks a lot Bryan.
Hi Bryan, I am trying to upgrade from 2008 R2 to 2012, its a stand alone server, as its production database, please let me know from where I have to start, as I am new in sql server … can you please share step by step document on upgrade.
my email id is : anilvidhani@yahoo.com …… Thanks in advance… Anil
Hi,Brayn I am working on SharePoint 2013 but the I am using SQL 2008 R2. now I want to update my DB to SQL 2012. So please let me know how it can done and data can't be impacted.
brian i need your help ASAP , i cant upgrade my sql 2008 r2, to 2012, i think i deleted before but now its sending me error, my email is luis1990twins@gmail.com inbox me please
Thank you!
Excellent video, thanks.