Hi Krasavita,

I could not find any method to directly restore on another server through query. Probably you can use osql command utility from inside the job to get it done. Alternately, you can create a windows scheduled task on the server2 using osql commmand line to resotre on server2.

Seraj Alam