Upgrade Advisor Recommendation Ignore During Upgrade

  • I have run Upgrade Advisor. I got report with potential upgrade issues. Some issues has to fix Before Upgrade and remaining issues can be fix Anytime or After Upgrade.

    My question is:

    What will happened if I do not fix Before isssues and go ahead with the Upgrade? (I understand that It's not good approach)

    Will upgrade Fail? OR Upgrade will be successful but we can not change compatibility level.........

  • It depends on the error. I looked at the GIF, and some of the data is cut off at the right, but it looks like it either an error with a linked server, or an error with a distributed proc. Neither one will block the upgrade, or even stop you from changing the compatibility level. What they will do is cause procs to fail when you try to run them after the upgrade.

    Again, I can't be certain that's what's going on, because I don't have the full report data, but it's what it looks like from what I can see.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply