SQL Backup failing error "0xe0008443 - one or more SQL Databases consistency checks have failed"

Problem

SQL Backup failing error  "0xe0008443 - One or more SQL Database consistency checks have failed."

 

V-79-57344-65085
The Server principal is not able to access the database "Database Name " under the current security context.

Error Message

0xe0008443 - one or more SQL Database consistency checks have failed.

V-79-57344-65085
The Server principal is not able to access the database "Database Name " under the current security context.

Cause

This error may occur if the BESA account has insufficient privileges to access SQL databases

Solution

1) Open SQL Management Studio

Connect to the Instance>Security>Logins

 

2) Find the Backup Exec account or the account used for the SQL backup in the List

If it is not found, add it and give it Sysadmin role

If it is already present, ensure it has Sysadmin role assigned

3) On the same "Select a page" option,  select "User Mapping"

4) Under "Users mapped to this login", select "master" database

5) Under "Database role membership for: master", select "db_datareader" and "db_datawriter"

6) Run a backup again to confirm resolution


Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)