SQL Server Errors or Failures from Error: 7927 to Error: 7947

SQLServerF1

 

Error: 7927, Severity: 10, Total number of extents is %I64d.
Error: 7928, Severity: 16, The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
Error: 7929, Severity: 16, Check statement aborted. Database contains deferred transactions.
Error: 7930, Severity: 16, Mirroring must be removed from the database for this DBCC command.

Error: 7931, Severity: 16, Database error: The FILESTREAM directory ID %.*ls for a partition was seen two times.
Error: 7932, Severity: 16, Table error: The FILESTREAM directory ID %.*ls for object ID %d, index ID %d, partition ID %I64d is in filegroup %d, but should be in filegroup %d.
Error: 7933, Severity: 16, Table error: A FILESTREAM directory ID %.*ls exists for a partition, but the corresponding partition does not exist in the database.
Error: 7934, Severity: 16, DBCC CHECK cannot proceed on database %.*ls because it is a Secondary Replica and either Snapshot creation failed or the WITH TABLOCK option was specified. Secondary Replica databases cannot be exclusively locked for DBCC CHECK. Reason may have been given
Error: 7935, Severity: 16, Table error: A FILESTREAM directory ID %.*ls exists for a column of object ID %d, index ID %d, partition ID %I64d, but that column does not exist in the partition.

Error: 7936, Severity: 16, Table error: The FILESTREAM directory ID %.*ls exists for column ID %d of object ID %d, index ID %d, partition ID %I64d, but that column is not a FILESTREAM column.
Error: 7938, Severity: 16, Table error: object ID %d, index ID %d, partition ID %I64d processing encountered file name “%.*ls” twice in the column directory %d container ID %d (for column ID %d).
Error: 7939, Severity: 16, Cannot detach database ‘%.*ls’ because it does not exist.
Error: 7940, Severity: 16, System databases master, model, msdb, and tempdb cannot be detached.
Error: 7941, Severity: 16, Table error: object ID %d, index ID %d, partition ID %I64d processing encountered file name “%.*ls” twice in the column ID %d (for column directory %d container ID %d).
Error: 7942, Severity: 10, DBCC %ls scanning ‘%.*ls’ table…
Error: 7943, Severity: 10, Table: ‘%.*ls’ (%d); index ID: %d, database ID: %d
Error: 7944, Severity: 10, %ls level scan performed.
Error: 7945, Severity: 10, – Pages Scanned…………………………..: %I64d
Error: 7946, Severity: 10, – Extents Scanned…………………………: %I64d
Error: 7947, Severity: 10, – Extent Switches…………………………: %I64d

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *