Had to do RBX restore didnt go to well :(
Ah dear it was one of those days where migration one was on the table and it had to be done.
Spoke to hc asked several questions
1. Does hc restore mysql usernames and passwords?
Answer No, it sets the sql password to something else
2. Does hc restore Microsoft sql usernames and passwords?
Answer No, it sets the sql password to something else
So i was sat their like $299 em
So i goes ahead but i made my own plan hc would do the following
1. Restore NT User accounts
2. Restore Website Data
3. Restore ODBC DSN's
4. Restore DNS
First of all i moved mail over no issues about 1min downtime for our users which is always good
Next i did a full mysql 4+5 backup restored them on the new server no problems including all users-names and passwords
Next ran hc backup, 2hrs later and 10gb of files i started to FTP it across
Starts rebuild, oh dear, hc wouldn’t rebuild eventually after an hour of messing about i created an empty mssql db and hc restored, took about 1hr 20mins for 50 user accounts.
Next i restored Microsoft sql databases quite simple using the backup hc had created a simple restore procedure can be run against mssql.
Now how to transfer mssql usernames and passwords?
Well good old Microsoft :)
http://support.microsoft.com/kb/918992/
Simple and easy, all users were restored with their passwords
After hc had rebuilt everything i checked dns oh dear it hadn't put any mail dns in, em if u don’t tick mail u don’t get any dns for mail, so i had to manually type 100 dns mail records :(
The fun continued i have no idea why but sites with asp.net 2.0 on previous server were restored with 1.1 :(
Anyways i sat there for two hours went through all our sites checked everything was working :)
HC take this as a suggestion research re-search, its possible to restore mysql and mssql usernames and passwords, i can understand ntusers no problems but if u reset all passwords you cause more downtime for end users.
Oh did i mention we decided to move from MSFTP to Serv-U u guessed it hc doesn’t support this so manual add 50 user accounts.
Oh and another thing even though hc settings had secondary dns ticked hc didn’t create secondary dns records.
Basically if the features were in place it would have been nice and quick, 10hrs of labor :( $299 for the app if it worked 100% id pay more but i don’t think its worth that amount im afraid.
Anyways that’s my super long rant, probably because ive been working for 36hrs straight :(
On a lighter note, our new load balanced hc 6.1 cluster is operational, he he and they said it wasn't posible :)
__________________
Chris Daley
Dwebs Ltd Director :: Company No. 05603664 :: Phone No. (UK) 0870 803 4423
www.Dhosting.co.uk - Web Hosting, Domain Registration, Windows 2003 NLB Cluster with HC 6.1!!!
www.Dwebs.ltd.uk - Web Design & Other Services
My views are my own and not those of my company.