Unable to save and error on DBCC CHECKDB

Question

I try to save my database ≈ 260 Mb

I have this error :

System.Data.SqlClient.SqlError : failure read function incorrect

So I try : DBCC CHECKDB ('myDatabase') PHYSICAL_ONLY

I have this error :

Msg 8921, Level 16, State 1, Line 1 Stop control. An error occurred while collecting the facts. Insufficient space in tempdb or inconsistency of a system table. Check out the previous errors.

I have same error without PHYSICAL_ONLY but the rest seems normal

DBCC CHECKDB ('myDatabase') WITH ESTIMATEONLY :

9357520 Kb => 9 357,52 Mb

SELECT SUM(unallocated_extent_page_count) AS [free pages], (SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB] FROM sys.dm_db_file_space_usage;

free space in MB : 30 389 Mb

DBCC SQLPERF(LOGSPACE)

tempbd : - Log size : 13 299 Mb - Space Used (%) : 0.01%

I do not know why this does not work

Edit : When I try xcopy (database offline) I get this error :

target volume does not support symbolic links

Answer 1

is it a physical or a virtual server? Please make a chkdsk on your filesystem where the database are stored.

Please also try a BACKUP DATABASE with CONTINUE_AFTER_ERROR:

BACKUP DATABASE AdventureWorks2012   
 TO DISK = 'Z:\SQLServerBackups\AdvWorksData.bak'  
   WITH CHECKSUM, CONTINUE_AFTER_ERROR;  
GO  

More information about this here:

https://docs.microsoft.com/de-de/sql/relational-databases/backup-restore/specify-if-backup-or-restore-continues-or-stops-after-error

Regards, Björn

Answer 2

I resolve my issue : since the CHECKDB did not send me anything extraordinary, I decided to export the tables one by one. And there a table did not want to be exported with exactly the same error. It was a temporary table I deleted it and now everything is working again. (Note: The DBCC TABLE was returning the same error : "An error occurred while collecting the facts. Insufficient space in tempdb or inconsistency of a system table")