Log shipping script

We are currently setting up log shipping using SQL 2000. We have a local
server on a 15 minute delay and a remote server on a 3 hour delay. I am
curious as to the process of recovering the logs in the event of a failover.
Has somebody ever done a script, or know of a way to automate the process of
"catching up" the application of the log files in the event of a failover?
Specifically I am looking to automate the process of recognizing the last
log applied and then applying the subsequent logs required to bring the DB
back online.
Any help would be appreciated.
Thanks
Ron
Please don't multi-post.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ron VZ" <rvanzant@.premierbankcard.com> wrote in message
news:uYUCrvlQEHA.368@.TK2MSFTNGP09.phx.gbl...
> We are currently setting up log shipping using SQL 2000. We have a local
> server on a 15 minute delay and a remote server on a 3 hour delay. I am
> curious as to the process of recovering the logs in the event of a
failover.
> Has somebody ever done a script, or know of a way to automate the process
of
> "catching up" the application of the log files in the event of a failover?
> Specifically I am looking to automate the process of recognizing the last
> log applied and then applying the subsequent logs required to bring the DB
> back online.
>
> Any help would be appreciated.
>
> Thanks
>
> Ron
>