Article ID: 54245
Article Type: Troubleshooting
Last Modified:
An integrity check on a SQL master database failed to run.
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)'
The integrity check fails on the master database because the master database cannot be checked for consistency like a user database.
Do not perform an integrity check on a SQL master database.