quackhandle1975 (11/26/2015)
Great article, a question I've just thought of (and it might go in your "Post Work" section) is a traceflag check. So if you have a number of traceflags (1222, 4199, etc) running in older ver of SQL would they still be running post upgrade? I have always copied over the databases from old version to new version of SQL rather than an inplace upgrade.Thanks
qh
Hello and thanks for the great question. I too do not like to do in-place upgrade and copy over the databases. Ensure that you change the compatibility level to the new version you have installed, unless there are specific reasons you need to use the older level. Be sure to document this too.
As for trace flags, you should document the existing trace flags and then review/compare them with the flags on the newer version of SQL. In some cases the old trace flags may not be needed any more. Like everything else, you should read and review before moving to a different version of SQL.
Hope this helps 🙂
Rudy
Rudy