philfreund wrote:Using the AAIP backups complicates my ability to restore the database backups to our testing and DR environments which I have to do monthly.
1. You can do AAIP backups with the copy_only setting, thus leaving logs intact (if this is your concern).
2. You can consider using SureBackup
for that, since it was designed with this use case in mind as well.