Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

please is there any checklist available for upgrading SQL server 2000 to 2012? What is your experience with performing this? Could be the upgrade performed directly at all, or will I need to go through 2000 -> 2005 -> 2008 -> 2012?

Thanks and regards, Matej

share|improve this question
If you are that many versions behind a refresh install on new hardware followed by comprehensive testing (while continuing to run existing setup in production) before considering such a large change into production. – Richard Jul 25 '12 at 8:40
Sure, I'm currently in a planning stage. There are multiple relatively small databases managed by that instance (~40 GB completely) and we want to upgrade mainly because of new features in SQL server 2012. – Matej Jul 25 '12 at 8:46

SQL Server 2012 supports upgrade from the following versions of SQL Server:

  • SQL Server 2005 SP4 or later
  • SQL Server 2008 SP2 or later
  • SQL Server 2008 R2 SP1 or later

Supported Version and Edition Upgrades

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.