ramana3327 (1/26/2015)

---

Currently the backups are residing in one server but database has to restore in another server.

I have to get that backup files to separate server and then restore database from that backup then run some DML after everything is done then delete the backup files from the local machine.

Current my plan keep the full backup in the local machine until next full backup with out deleting but needs to check the full backup date. If the full backup date is recent than the backup date on local machine then delete the old backup and keep this ..

Is it possible through Stored procedure?

If you have any of sample code, please provide to me.

Thank you