- Posts: 1
- Liked: never
- Joined: Sep 03, 2019 9:48 am
- Full Name: Ross
we will deliver a very simple two-node SQL 2016 AlwaysOn config later this month and we are testing backup & restore performance and DB replication as well and we are unable to have consistent Tlog backup jobs. Tlog backups (and truncation) are required every 2 hours on the primary node and the job keeps failing with the message: "Collected SQL Server transaction logs do not match any existing database backup" and then the names of the local replicated DBs...
Documentation on this subject is very poor, we've seen many people complaining about this over the years, there's no final conclusive answer and all we found in this forum is to have both nodes in the same job... no big deal though... so the question: how do we back up SQL AlwaysOn nodes that require tlog truncation every X hours? Why is the official documentation so poor?
- Veeam Software
- Posts: 18356
- Liked: 1575 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Posts: 349
- Liked: 93 times
- Joined: Dec 13, 2015 11:33 pm
Users browsing this forum: No registered users and 22 guests