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