Tuesday, September 1, 2009

SQL Server 2000 to 2005 upgrade

Upgrade process from SQL2000 Standard to SQL20005 Standard

First check versions of SQL Server. You can do this by running SELECT @@VERSION on the master DB. For Analysis Services you can check by opening and clicking Help - About. 8.0.2039 = SP4

  1. Make backup of all DB's
  2. Apply SQL2000 SP4 if needed
  3. Apply SQL2000 Analysis Services SP4 if needed
  4. Install SQL2005
  5. Select the following
    1. SQL Server Database Services
    2. Analysis Services
    3. Workstation components, Books Online and development tools
    4. Others if needed
  6. Click Advanced
  7. Ensure pathing for each component
  8. Default Instance
  9. Select the following
    1. SQL Server Database Services 8.00.2039
    2. Analysis Services 8.0.2039.0
  10. SQL Server Authentication Mode
  11. Analysis will run
  12. Use the built-in System account (Local System)
  13. Latin1_General
  14. Accent - sensitive
  15. Dictionary order, case-insensitive, for use with 1252 Character Set.
  16. Install
  17. Install latest SP's / updates

No comments:

Post a Comment