The Log Shipping option within Red-Gate offers some of this. For us, we wrote our own, we generate a backup with a stored proc with the Red-Gate command and then call a stored proc on the destination server telling it it is ready for restore and use the Red-Gate commands to restore. Has more details than that but that is the basics. The Red-Gate Log Shipping works, we just needed a few more items for our environment, so we started with what Red-Gate creates and added the items we needed here.
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
2 servers :
each night, sqlbackup pro backup DB_server1 by job, and restore on DB_server2 by job too...
i know that is possible with dts & jobs ... but sql backup could offer this possibility later?
in summary, have a possibility to create restore job with sqlbackup...