upgrade

• owen_zeng

  Old Hand

  Points: 340

  More actions

  July 29, 2015 at 12:34 am

  #302810

  hi,

  we have two way to upgrade sql server.

  1.sql server upgrade guide

  2.instal a new instance with higher version.backp&restore to the new instance.

  which way is better?and what is the difference.

  thanks.

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  July 29, 2015 at 3:59 am

  #1815647

  owen_zeng (7/29/2015)

  ---

  hi,

  we have two way to upgrade sql server.

  1.sql server upgrade guide

  2.instal a new instance with higher version.backp&restore to the new instance.

  which way is better?and what is the difference.

  thanks.

  Situationally, either one works. For the major upgrades, not a service pack or cumulative upgrade, I prefer the second approach. The reason is, you can immediately undo it if there's a problem. Whereas, with the first approach, once you start the process, you're committed to getting your upgrade done successfully. That added safety valve of the second instance counts for a lot.

  ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

• owen_zeng

  Old Hand

  Points: 340

  More actions

  August 3, 2015 at 8:17 pm

  #1816986

  Thanks a lot!I also prefer the second one .

  when should i use the first one?

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  August 3, 2015 at 8:45 pm

  #1816989

  All the minor upgrades. And, when you don't have a choice. It's just not as safe as having a second server sitting right there.

  ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

• Gail Shaw

  SSC Guru

  Points: 1004494

  More actions

  August 4, 2015 at 12:34 am

  #1817003

  Cases where it's acceptable to reinstall the server if the upgrade fails.

  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