Michael Hendry wrote:
> Adrian Midgley wrote:
>> er ... if the main server goes down, why not have one person
>> click on one icon which causes the standby server to change
>> its name (and/or IP address) to that previously used by the main
>> server...
>>
>> Then restart the applications on the clients using the single
>> set of icons for accessing the clincial server.
>>
>> ?
>>
>> You can probably do it automatically possibly involving DHCP,
>> but one click isn't too bad.
>
> Don't think NT allows you to change the name of a server.
>
> This could be regarded as a useful security feature, otherwise
> unthinkable in a M$ product.
Yes you can do this using a piece of software called Octopus, however
unfortunately this has proved incompatable with current versions of M so if
you are running M over NT its not currently a starter though we did this for
some years. The way to do this now if you are using MikeRoweSoft (well they
reckon the poor lad is infringing copyright when that is his name and he
writes software! more might over right) is use Enterprise version of Win
2000 Server and set up Transaction Log Shipping this copies the actions
performed in the lead SQL machine to the secondary and then applies them,
typically the secondary will be about a minute behind, all clients then have
2 versions of the client when lead fails shut down the client and open the
other with pointers to the secondary machine and find that doc that set up
this (*&%*(&) system!
- -
Alistair
|