What is an advantage or disadvantage for not upgrading database server?

If you don't:

  • it will be unmaintainable at some point because of OS, version, patch, whatever
  • hardware failure may force an upgrade at the wrong time

What you gain:

  • older code can be simplified with new constructs (eg ROW_NUMBER)
  • far better error handling (TRY/CATCH)
  • engine improvements: most queries will run quicker on a later version

MS don't support it anymore either


GBN is spot on with his analysis - I'd just add that something that can buy you time, if your company has the technology, is to virtualise this legacy database server, either as a new build or as a clone/P2V. This will buy you time in that you'll be better protected against hardware failure.