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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning