MSSQL Server upgrades, maintenance, migrations - nightly between 10PM-5AM

Discussion in 'HSphere Cluster 1' started by Stephen, Jun 6, 2017.

  1. Stephen

    Stephen US Operations Staff Member

    We will be syncing, upgrading, and doing MS SQL Migrations all week in the evening hours. Some of the upgrades and maintenance will be a simple service pack application, others will require full upgrades.

    MSSQL7 will be starting tonight with service packs and migration. We will update the thread for others daily before the server maintenance occurs.
  2. Stephen

    Stephen US Operations Staff Member

    MSSQL7 Maintenance will begin in about 10-15 minutes.
  3. Stephen

    Stephen US Operations Staff Member

    The Service pack installation is still running, nearing completion!
  4. Stephen

    Stephen US Operations Staff Member

    MSSQL7 is now upgraded, migrated, live. The way we are doing these migrations is via a clone of the stopped service, so it has a same state intact when it goes live. The SQL Services are required to be stopped to do the updates, so we keep them offline while running the service packs.
    Jonh Wick likes this.
  5. Stephen

    Stephen US Operations Staff Member

    MSSQL8 will be upgraded, migrated and completed in the same timeframe tomorrow.
  6. Stephen

    Stephen US Operations Staff Member

    MSSQL8 will be undergoing maintenance and migration in the next 5 minutes, and SQL services down while it processes.
  7. Stephen

    Stephen US Operations Staff Member

    MSSQL8 is complete, upgraded, and live now.

    MSSQL10 will being a version upgrade soon tonight, and MSSQL13 will undergo upgrade, maintenance, and migration tonight/tomorrow morning. MSSQL11 and MSSQL12 will have version upgrades starting tomorrow evening and the day following into the weekend. MSSQL14/15 will update and migrate on Friday and Saturday nights respectively completing all the cluster1 windows server moves.
  8. Shubham

    Shubham Windows Team Staff Member

    MSSQL10 will be undergoing maintenance now
  9. Stephen

    Stephen US Operations Staff Member

    MSSQL10 is up and running, but some databases may not be fully upgraded which we are correcting as we see in logs and access attempts failing. If you have a DB on MSSQL10 that isn't working let us know via ticket or live chat and we'll check it out and get running ASAP.

    I will mention there are a few that have had issues in their programming since upgrades done, items like ambiguous syntax records in calls to columns that exist on multiple tables, where code is needed to edit and put the tablename.columnname like it should have been made from the start, but some prior versions still worked with the code.
    Last edited: Jun 8, 2017
  10. Stephen

    Stephen US Operations Staff Member

    MSSQL13 maintenance will be starting in the next 20 minutes.
  11. Stephen

    Stephen US Operations Staff Member

    MSSQL13 is completed! Can see live connections into it and running now.
  12. Stephen

    Stephen US Operations Staff Member

    Just a reminder that MSSQL14 will be moving & upgrading tonight, and MSSQL11 will be moving early tomorrow morning but with a complete version upgrade.
  13. Stephen

    Stephen US Operations Staff Member

    MSSQL14 maintenance and upgrades will begin in the next 20ish minutes.
  14. Stephen

    Stephen US Operations Staff Member

    MSSQL14 is up and going, the only error coming on the server since the upgrades was also coming before the upgrade regarding one user with a failed login.
  15. Stephen

    Stephen US Operations Staff Member

    MSSQL11 will begin its major full upgrade in the next hour or less, as part of this the server actually changes names since we clone it over and only then do the upgrade, making a rollback possible if such were required.
  16. Shubham

    Shubham Windows Team Staff Member

    MSSQL11 is upgrade and running, but some databases may not be fully upgraded which we are correcting as we see in logs and access attempts failing. If you have a DB on MSSQL11 that isn't working let us know via ticket or live chat and we'll check it out and get running ASAP.
  17. Stephen

    Stephen US Operations Staff Member

    MSSQL15 will be upgrading and migrating tonight ~11pm timeframe!
  18. Stephen

    Stephen US Operations Staff Member

    MSSQL15 will be starting upgrades, maintenance and migration in the next few minutes, MSSQL12 will follow with a complete upgrade process required. This involves remapping logins etc if there are any errors in the process, and can result in a much longer outage than the process on MSSQL15.
    These will be the final shared windows servers to migrate!
  19. Stephen

    Stephen US Operations Staff Member

    MSSQL15 is live again and up and running.
  20. Shubham

    Shubham Windows Team Staff Member

    MSSQL12 will be undergoing maintenance now

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services