SQL Server Performance

In place upgrade

Discussion in 'SQL Server 2008 General DBA Questions' started by semje, Jul 18, 2011.

  1. semje Member

    Can you do an in place upgrade from SQL Server 2000 --> SQL Server 2008 or do you have to do a side-by-side upgrade?
  2. satya Moderator

    yes it is possible to do Inplace upgrade, however you should be careful doing so as it will replace the exisiting SQL 2k services and for a backout it may not be possible quickly as you need to uninstall and reinstall SQL 2000 again. Whatever is the choice make sure you have taken backups for all the databases and scripted out the logins.
    More information check my talk in Tech-Ed last year on teh subject - http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DBI319 link
  3. semje Member

    Thanks

Share This Page