Sql-server – Unable to save and error on DBCC CHECKDB

backupdbcc-checkdbsql server

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

Best Answer

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

Related Question