Setting up backup Server

Our customer wants to have two Application servers: First primary Navision Attain server and second backup Navision Attain server. So the question is: is it possible to setup backup server that all clients conects to it automatically if primary server goes down? Primary server would make dbf copy to backup server every night but how to make users to connect to backup server automatically? Maybe somehow it’s possible to make backup server as mirror server (every transactions made to primary’s server db will be made to secondary’s also)?