DBCC check failed for database

Article ID: 54245

Article Type: Troubleshooting

Last Modified:

An integrity check on a SQL master database failed to run.

Symptoms

An integrity check fails on a SQL master database with the following error message:

Description: DBCC CHECK failed for database [master_cvjob_jobID] on proxy SQL Server [name_of_Server]. Error [Microsoft.SqlServer.Management.Common.ExecutionFailureException:Page (1:10) in database ID 5 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'. CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 99)'

Causes

The integrity check fails on the master database because the master database cannot be checked for consistency like a user database.

Resolution

Do not perform an integrity check on a SQL master database.

1 Commvault Way, Tinton Falls, NJ 07724 Sitemap | Legal Notices | Trademarks | Privacy Policy
Copyright © Commvault | All Rights Reserved.