Basically we want to run our office based windows application that runs all day to day office stuff, from remotely hosted DB. The reason for this is that we are running our website from the same remote server, and our office system and website are constantly updating each other.
So if we have a good managed hosting company looking after our server, but can it really take days to get it back up if we have a major hardware failure? - This is the main concern of our inhouse IT guy - so if its a good hosting what steps can we take to make sure any possible downtime will be minimum, and what sort of time would you expect a good hosting company to get a server back up (with all data re-loaded) for example if we have a disk or motherboard failure ?
Well, as long as it is running in a raid array, even if the harddware fails, it should not take all day to swap the drives to a new chasis and get the server back up and functioning. At the very most, a few hours at best. Hardware fails are generally easier to recover from with raid, vs a software corruption / compromise. I'd check with the host however just to be safe.
A managed hosting company that has hardware replacement plans in place (and the hardware in-stock!) should be able to have the server back on-line within 2-4 hours. All that said, as others mentioned, a RAID array will help you avoid the downtime in the first place.
Mike G. - Limestone Networks - Account Specialist Cloud - Dedicated - Colocation - Premium Network - Passionate Support DDoS Protection Available - Reseller Program @LimestoneInc - 877.586.0555