PowerShell script exchange
Post Reply
Wtrippler
Lurker
Posts: 2
Liked: never
Joined: Jan 12, 2018 1:58 pm
Full Name: Wendy Trippler
Contact:

SQL Transaction Jobs

Post by Wtrippler »

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?
nielsengelen
Product Manager
Posts: 5797
Liked: 1215 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: SQL Transaction Jobs

Post by nielsengelen »

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
Post Reply

Who is online

Users browsing this forum: Amazon [Bot] and 13 guests