-
- Lurker
- Posts: 2
- Liked: never
- Joined: Jan 12, 2018 1:58 pm
- Full Name: Wendy Trippler
- Contact:
SQL Transaction Jobs
I have a situation where on a monthly basis a production SQL database is taken offline and is replaced with a different database. When this occurs the Veeam hourly SQL transaction log backup begins failing, until the main backup job is ran again. Is it possible to say if SQL transaction log states failed, re-run the main backup job?
-
- Product Manager
- Posts: 5797
- Liked: 1215 times
- Joined: Jul 15, 2013 11:09 am
- Full Name: Niels Engelen
- Contact:
Re: SQL Transaction Jobs
This would require some custom scripting which would run a script after the job, catch the error and then perform an active full. This is not possible by default.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
GitHub: https://github.com/nielsengelen
Who is online
Users browsing this forum: Amazon [Bot] and 13 guests