I have DB of size 170GB. One of the table has 339500 rows out of which around 2000 rows are corrupted.
When I tried backing up the database I get
"Backup with 'Checksum' gave error"
SQL Server version: 2008 R2
Edition : Express edition
Whenever DBCC Checktable is executed I will get below error "Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors."
When the following query was run ,
SELECT * FROM [msdb].[dbo].[suspect_pages]
we found that few pages in a table was corrupted.
But presently I don't have latest good(non corrupted) backup. DBCC repair with allow data loss is also not working.
I have found the rows in the table which are corrupted but is there any way to get rid of these corrupted rows? After searching for solution in the internet, I found out that moving the rows from corrupt database to new database is the only solution which is not feasible for me now. Other than using a 3rd party tool for repair is there any other method to backup without the corrupted data?
Previous month I could able to backup the Db
"Backup without 'Checksum'" , but now even that doesn't work.
DBCC CheckDB result given for reference in this link