When backing up SQL databases you might get the following error message.
V-79-57344-65085 - There was a problem running the DBCC.
DBCC results for “Database”
To resolve the error take the following steps.
1. Connect to SQL Management Studio
2. Run manual SQL backups on the Database in question
3. Right click Database and select “new query”
4. Type the below commands exactly as is. It will only scan the Database and report what is wrong with it.
5. In my case it was a table miss match and the report said I should run DBCC UPDATEUSAGE
6. I created a new query with the following details:
DBCC UPDATEUSAGE (0);
After this my Backups completed successfully again.
When installing Backup Exec 2010 or 2012 in a Domain Environment it will automatically create a Backup service account and will automatically assign the correct rights to the account.
Problem is in a Virtualized environment were you have no physical Domain Controllers your Hypervisor is usually in a Workgroup. So when installing Backup exec it creates a Service account for the workgroup but not for the domain.
Below is the steps to manually create an account for the domain as well as to assign the correct permissions and rights.
1. Create a normal account in Active Directory called “Backup” and give it a password.
2. Set the password of the account to never Expire
3. If you will be backing up the System state of Domain Controller make the account part of the Domain Admins group.
4. The account should have its primary role as Domain Admin.
5. Assign the following rights to the account.
The below will happen in the Domain Controllers Security Policy as well as any Security Policies that control your member servers.
Act as part of the operating system
Backup files and directories
Create a token object
Logon as a batch job (Windows 2008 only)
Logon as a service
Manage auditing and security log
Restore files and directories
Take ownership of files and other objects
Also make sure the account is not added under the following:
Deny logon as a service
Deny logon as a batch