Skip to main content

[Solved] 12.5.8850 SQL backup error even though data is backed up ok

Thread needs solution

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
0 Users found this helpful

Hello Alan, 

Is the domain\Acronis user part of the sysadmin role for the ACRONIS named instance? 

Please add sysadmin role for this instance as well and rerun the backup. 

Thank you! 

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.

 

Just confirming that adding the sysadmin role as per Igor's suggestion fixed the issue.