Upgraded SQL 2005 clustered environment to SQL Server 2008

Leave a comment (0) Go to comments

Today, I was having an assignment of upgrading a SQL 2005 two node clustered environment to SQL Server 2008. I thought off, that I am going to spend my whole night for this upgrade but somehow, it went very smoothly.

Unbelievable but yes, No down time is required to upgrade SQL 2005 clustered environment to SQL Server 2008. pre upgrade task and testing was all completed, Today I just need to do inplace upgradation. I started following up the Microsoft article, http://msdn.microsoft.com/en-us/library/ms191295(v=SQL.100).aspx, believe me, this rocked there is no deviation found, worked like a charm. I didn’t recoded this session as this includes some confidential information.

Here are the steps, which we performed to complete this Upgrade project.

Pre Upgrade Activities

  1. Windows guys have already taken the OS level backup, which covered all files at OS level.
  2. Ensured that we have CD’s of Windows OS and SQL Server 2005 and 2008 (2005, just to cover worst case scenario)
  3. SQL Server Online full backup to local disk and then moved down to another drive for media reliability purpose.
  4. Performed a restoration on one test server, just to ensure backup files are good and there is no corruption in backup files.
  5. Application services were stopped as per the downtime window.
  6. Again SQL Server Full backup to local disk. (Now we have two copies of backup)
  7. Windows Registry backup at OS Level
  8. Put the SQL cluster resources in offline mode.
  9. Manually, copied all databases file (.mdf,.ndf and .ldf) to the local backup drive backup  drive, just to ensure, we should be back in business, if something goes wrong.
  10. rechecked the that we are good with backups
  11. Started SQL Server cluster services, now SQL Services are online, as it was running, now we are ready to proceed with upgradation.

Actual Upgrade Activities


I already have a hard copy of MS article, so I just started following that up, here I go

  1. Currently SQL resources are running (Server 01), which is a active node.
  2. As planned, I started upgrade activity of Passive Node (Server 02), and double click on Setup.exe
  3. Step 2 of article, "Windows Installer 4.5 is also required, and may be installed by the Installation Wizard. If you are prompted to restart your computer, restart and then start Setup.exe again.", was not required, as it was already installed.
  4. It started SQL Server Installation Center and selected Upgrade from SQL Server 2000 or SQL Server 2005 and it completed System Configuration Checker.
  5. Entered the Key, license key (Now we are on Step 6 of MS article)
  6. On the License Terms page, Checked the accept box and Clicked Next to continue
  7. Instance page, in my case I have only one instance, so selected that SQL Server instance to upgrade to SQL Server 2008
  8. Feature Selection page, I didn’t changed any option
  9. 2 more next,
  10. Full-Text Search Upgrade page, we were not using full text services, so nothing to specify.
  11. It again checked some configuration, and come up with report, which looked OK, (Now we are on Step 16 of MS article)
  12. Finally, clicked the "Upgrade" button
  13. It continues…… I keeping my finger crossed as this was a first production server In place upgrade for me.
  14. finally it completed and given a option to close the upgrade window.
  15. Restarted the server (Server02)
  16. Moved SQL Server cluster resources to passive node (Server 02), which we just run the SQL Server 2008 set up,  (During this upgraded SQL server is online and running with SQL 2005 version)
  17. Important point to mention, after the failover, SQL server is running with SQL 2008 version. At this point of time, we have SQL Server 2008 binaries in (Server 02) and SQL Server 2005 binaries on (Server 01)
  18. Started again the setup.exe on (Server 01), repeated the same steps.
  19. Finally it completed and given a option to close the upgrade window.
  20. Restarted the server (Server 01)
  21. Done the failover again from (Server 02) to (Server 01), which worked perfectly fine.
  22. Finally we completed in place upgrade of SQL 2008 technically.
  23. Again backed up all databases.
  24. Checked for Logs to ensure there is no pending stuff.
  25. Finally asked application user for testing and there was no major issue reported which was directly related to this upgrade activity.

Important Note and Learning:

  1. During this upgraded SQL server is online and running with SQL 2005 version.
  2. Once we completed the upgrade on Passive Node (Server 2) and moved the resources to (Server 02 from Server 01), SQL server is running with SQL 2008 version
  3. Upgrade has not install SSIS services. We need to manually installed SSIS services and configure to run as cluster resource, by default SSIS runs as local services.

Thanks you very much for going thru with this article. Just have "http://msdn.microsoft.com/en-us/library/ms191295(v=SQL.100).aspx" handy with you to start you own in place upgrade project.

Tags : Upgrade SQL 2005 clustered environment to SQL Server 2008, sql server cluster upgrade, sql server upgrade on cluster, how to perform inplace upgrade on sql cluster, Inplace upgrade SQL 2005 clustered environment to SQL Server 2008 , inplace sql server upgrade from sql server 2005 to sql server 2008, how to upgrade sql server cluster, SQL 2005 clustered environment to SQL Server 2008, SQL Server 2005 clustered environment to SQL Server 2008, SQL 2000 clustered environment to SQL Server 2008,Upgraded SQL 2000 clustered environment to SQL Server 2008,upgrade SQL 2000 clustered environment to SQL Server 2008, inplace sql server upgrade from sql server 2000 to sql server 2008.Upgrade SQL Server 2000 to 2005 or 2008?,how to upgrade sql server, how to upgrade sql server 2005 instance to sql server 2008,How Upgrade to SQL Server 2008,How to Upgrade to SQL Server 2008, How to migrate from SQL Server 2005 to 2008,How to migrate SQL Server 2005 cluster to sql server 2008,Upgrading to SQL Server 2008,Sql Server 2005 to 2008,Implementing Upgrade of SQL Server 2008,sql server Upgrade Activities,

EOF - Upgraded SQL 2005 clustered environment to SQL Server 2008, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.