Wednesday, March 18, 2009

Planning the full set of updates to SQL05.  One server, DEV, was rebuilt last Sept so can just be upgraded by installing SQL05 on top of SQL00.  This will keep the developers happier - less down time.  The other two important servers, TEST and TRAIN, really do need full rebuilds;  the structure is a bit of a mess, and multiple releases were installed on top of each other.
Rebuild steps - all are VMware servers, so we can fall back easily: 
  1. Copy a backup of the CLICK sites off to an archive - 30 to 60 minutes
  2. deactivate the old VM
  3. Create the new VM with the same name and IP - Tom B - 2 - 2.5 hours - this can be done aheady of time but not start it until the old one is deactivated.
  4. Install SQL Server + SP3 + BOL - 1 hour +
  5. Install CLICK - 1 hour - 5.5.3 plus the framework patches 01, 05, and 06
  6. Copy the sites back - 30 - 60 minutes
  7. Create and load the CLICK sites - 60 minutes (can overlap a bit with 6)
  8. test - if fails then Tom B plus Net Ops needs to restore the old VMware site.

    On TRAIN the training site will be restored from PROD, not the old one (better keep a copy just in case).

No comments:

Post a Comment