Hi, my dear experts,
Please help me figure out what went wrong.
I created these maintenance plan backups (full, diff and tlog), and they have been running "successfully", at least that’s their histories have shown. However, now upon a closer look, there were no backup files existed on the destination locations.
Months ago, they were there.
So here are what I have tried:
Cleanup job wipe them out? No, I run them ad hoc, still no file. And the job completes too fast, within a minute.
Destination permission issue? Unlikely: 1) it did not error out; 2) I verified that service account is on that network share drive and is the same account in history message Exec as user; and 3) my ad hoc run was able to create a subfolder on the destination with current time stamp.
High Availability issue? Maybe but why? My initial plans were setup before the AG was hookup, and now this box is the primary on a two node cluster. Following note is from the maintenance screen:
The selected backup type is not supported on a "Always on secondary replica"...
And sending me to Microsoft webpage : http://go.microsoft.com/fwlink/?LinkId=208213
Active Secondary's: Backup on Secondary Replicas.
But I am sure, I am trying to backup the primary.