[Solved] 12.5.8850 SQL backup error even though data is backed up ok
See attached redacted log file.
User domain/Acronis is member of Administrators and Backup Operators and also has sysadmin rights in SQL.
If I run SQL Management Studio when logged in as domain\Acronis I can execute the failing SELECT statement without a problem.
It may be unrelated but if I use SQL Man. Studio on the ACRONIS SQL instance when logged in as domain\Acronis I am unable to access the Model database (resulting in a similar security-type error) but can access all others databases.
Is there a fix for this?
Thanks
Alan
Attachment | Size |
---|---|
activity_log.txt | 7.47 KB |

- Log in to post comments

Hi Igor
The ACRONIS instance has only BUILTIN/USERS and SA as logins. Unfortunately I do not have the sa password but once I get it I will add the domain\acronis account and try the backup again, then report back here.
Thank you for your help - it seems likely you have given the answer.
Alan.
- Log in to post comments

Just confirming that adding the sysadmin role as per Igor's suggestion fixed the issue.
- Log in to post comments