Comments
Sort by recent activity
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...