July 29, 2015 at 12:34 am
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.
July 29, 2015 at 3:59 am
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
August 3, 2015 at 8:17 pm
Thanks a lot!I also prefer the second one .
when should i use the first one?
August 3, 2015 at 8:45 pm
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
August 4, 2015 at 12:34 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply