Activity overview
Latest activity by doddg
eddie davis wrote:
Hi Graham
Thank you for your post into the forum.
What you are seeking can be achieved, please use the example script below and modify it to suit your needs:
DECLARE @errorcode INT
DECLARE @sqlerrorcode INT
---- snip snip
Many Thanks
Eddie
Hi Eddie,
thanks for the script.
One question, can I build this into the backup script (similar to what I do with the Enterprise Manager). Then I can schedule the backup to run, and as long as the backup is successful start the second step to restore the backup to the archive database.
Regards,
Graham / comments
eddie davis wrote:
Hi Graham
Thank you for your post into the forum.
What you are seeking can be achieved, please use the example script below and modify it to suit your needs:
DECLARE @errorcod...
Scripted restore to another Db
Hi to all,
new to the forum and also SQL Backup so please excuse any newbie errors
I use Backup 6 for daily backups of our live Db and would like to setup a job that restores the previous days ba...