I have a job setup that copies transaction logs for log shipping purposes.
It seems to be working, I think, but i cant verify that because of the following error:
2021-08-22 21:00:00.86 Starting transaction log copy. Secondary ID: 'c29f....'
2021-08-22 21:00:00.87 Error: Could not log history/error message.(Microsoft.SqlServer.Management.LogShipping)
2021-08-22 21:00:00.87 Error: Only members of the sysadmin fixed server role can perform this operation.(.Net SqlClient Data Provider)
I checked permissions, and clearly Im sysadmin...
So why is it complaining?
