I have two servers with Sql Server 2000 Enterprise installed. In the main server i am making a complete backup of the database every day at 2am and other backup every 10 minutes of transaction logs. This file are saved on the second server.
If the main server falls i want to take the file of backup full and the files of backup of transaction logs and upgrade the database in the second sever.
Is it possible to make it automatically ?

Thank you