• I would like to add couple of aditions/changes:

    1. You don't need to use xp_cmdshell to find whether the new backup is available. You can refer to MSDB database to find all backups that have taken place

    2. In case you need to move the backups on other server, if its on WAN you can do so by FTP, if in same domain, you can take backup on the target server itself.

    I had done this in early days when I was more a developer and a fresh DBA. I had written a VB program by implementing timer control.

    I will give complete steps as per the points added in short while.

    Thanks,

    Girish