0

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

  • Can you restore a backup to another server and run the check there? – Erik Darling Nov 26 '17 at 0:15
  • I don't have any backup – xav-stargate Nov 26 '17 at 8:21
  • try to run dbcc checkdb on the system databases and share the results – Eduardo Pivaral Nov 26 '17 at 15:14
  • @EduardoPivaral Same error on the begining : 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. [..............] CHECKDB found 0 allocation errors and 0 consistency errors in database 'myDatabase' – xav-stargate Nov 27 '17 at 13:41
  • How much free space is on the drive where your tempdb data file is? If there is free space there, is tempdb configured for auto-growth? how much space does it add each time it grows? Is there enough free space for it to grow at least once? – RDFozz Nov 27 '17 at 23:30
0

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

  • chkdsk : none error (4 disk : RAID 5) & same error with the continue_error : failure read – xav-stargate Nov 27 '17 at 12:08
0

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")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.