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
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply