June 11, 2026 at 1:52 am
Please I am hoping for some feedback
Specifications:
Windows Server 2022
SQL Server 2022
Availability Group with 4 replica
I am trying to make sure I am using the best method of backing up my databases. I cannot use the Ole Hollengren jobs because of my environment
Currently I have all four nodes set up with FULL, DIFF and TRN backups using SQL Maintenance plans. I have the backup preference set to primary and there are no copy only settings. All backups are using two folders depending on which node is primary. Node 1,2 backup to folder A, Node 3,4 backup to folder B. Backup jobs are going fine and when there is a fail over the backup run on the correct folder - no problems
I am doing FULL on Saturday, DIFF Daily, and TRN every 30 minutes. When there is a fail over the DIFF and TRN backups start up in the new folder just fine.
Q: am I crazy for setting up my backups this way
My restore plan is to take the FULL, DIFF and TRN files move them to a folder on the server and then do a restore using the GUI in SSMS,
Today I tried to perform a test restore, so I basically take a FULL, DIFF, and a few TRN backup files and move them to a TEMP folder. I then do the restore and choose the backup files. Well I have tested this in the past and it worked just fine - the restore can see all the backup files - FULL, DIFF and TRN without issue.
Today I kept getting an error - ...Full backup not available sorry I do not have the exact error message
Q: Is the backup chain broken when a fail over occurs?
Your feedback is appreciated.
Jeff
June 12, 2026 at 2:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
June 19, 2026 at 10:03 am
Q: am I crazy for setting up my backups this way
A: whatever works for you, and your HA/DR requirements. Depends so much on what infra is available to you (NAS, SAN, Cloud Blob, etc) and on your backup policies.
Q: Is the backup chain broken when a fail over occurs?
A: you would need to take the FULL, DIFF and TRNs from the same Primary Node; maybe the Primary switched from 3-4, for example, meaning the FULL was from 3, but the DIFF/TRN was from 4?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply