SQL backup jobs are failing because step 2 fails with the following log msg:
Executed as user: NT AUTHORITY\SYSTEM. The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE. [SQLSTATE 42000] (Error 4208) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
The command causing the error is
BACKUP LOG UnityDb TO UnityDbDump
Replace LOG with Database and all works OK; however, that is not really a solution.
It's partner server, located at the other end of the country is also failing the same job with a slightly different log message:
The job failed. Unable to determine if the owner (<Domain>\UnityInstall) of job SqlNightlyBackupJob has server access (reason: Could not obtain information about Windows NT group/user '<Domain>\UnityInstall'. [SQLSTATE 42000] (Error 8198)).
I would like to know my next step.
Thank you in anticipation.