MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4) - Completed

Stephen

US Operations
Staff member
MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4)


MSSQL11 has experienced in the last 6 months 3 RAID failures with new drives installed on 2 of those occasions to fix the problem. This is abnormal and looks to be hardware related, so we will be migrating MSSQL11 off to a new server to resolve this problem.

The new server will also upgrade from dual to quad CPU giving more overall power to the server. The current server is a dual 2.3Ghz AMD server, and will move to a quad 2.33Ghz Intel.

During this migration it will be required to turn off the SQL services and copy the MDF/LDF files to the new server. This process will take between 1 and 4 hours to complete and bring online on the new server. During this time you may wish to put a custom error message or note of maintenance on your site as the DB will not be available.

We will begin the process at 1am EDT(GMT-4) Sunday Oct 4th and it should be completed by 4am, we have scheduled at this time to minimize impact as much as possible, and give enough notice to prepare for the migration.

To know if you have your MSSQL database hosted on this DB server, login to your end user panel, then go to 'Databases -> MSSQL -> MSSQL DBs'. If you see mssql11 next to label 'Hostname' this migration will affect you, otherwise it will not.
 
Re: MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4)

We are starting this in about 1 hours time!
 
Re: MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4)

We are going to start migration. SQL server is going off on MSSQL11 to start copy data on new SQL server.
 
Re: MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4)

Data copy is going well since we stopped sql server
 
Re: MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4)

The data is copying well, but looks like the amount of data included is going to take longer than anticipated at the current speeds of the copy. At this point it looks like it will be an additional 45 minutes to 1 hour.
 
Re: MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4)

SQL server is up and working fine on new server now. We are now working to make HSPHERE management up on new server.
 
Re: MSSQL11 Migration Notice Sunday Oct 4th, 1am-4am EDT (GMT-4)

We have installed HSPHERE. Hsphere tested and working to control Database's on server.

Migration completed.
 
Back
Top