Questions tagged [dbcc-checktable]
Use the dbcc-checktable tag for questions about how to implement, understand, and diagnose issues with the SQL Server DBCC CHECKTABLE command
11
questions
4
votes
1
answer
249
views
Do I really need a backup when using REPAIR_ALLOW_DATA_LOSS?
Reluctant DBA here.
Do I really need a backup when using REPAIR_ALLOW_DATA_LOSS? I am well aware MS recommends doing a backup.
What's the worse that could happen if I run a DBCC CHECKTABLE using ...
- 143
0
votes
0
answers
23
views
DBCC error with sys.syscolpars DB upgrade failing
Consistency error in DB.
1 page from sys.syscolpars table is missing.
There is no any impact but the thing is can't able to upgrade the DB from 2008 to higher version. Backup restore fails. Old good ...
- 51
3
votes
2
answers
841
views
DBCC consistency error in SQL Server
I ran DBCC CheckDB in our Production SQL Server 2014. It reported back with one consistency error:
Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'MYDB') WITH NO_INF..." failed ...
- 73
0
votes
1
answer
358
views
Is there any specific differences on table level integrity check between DBCC CHECKDB and DBCC CHECKTABLE?
I've faced with allocation error in one of our databases while running DBCC CHECKDB on it. It throws below-mentioned error:
Msg 8947, Level 16, State 1, Line 5
Table error: Multiple IAM pages for ...
- 205
0
votes
2
answers
786
views
What causes DBCC CHECKTABLE to return "session is in the kill state"?
A scheduled job step ran DBCC CHECKTABLE on a table but returned the following error:
Cannot continue the execution because the session is in the kill state. [SQLSTATE HY000] (Error 596). The step ...
- 1,066
0
votes
1
answer
145
views
Overhead associated with DBCC CHECKTABLE?
Have a logshipped VLDB and don't run DBCC CHECKDB on primary due to the long running periods of high CPU and tempdb usage. Have read about DBCC CHECKTABLE as a possibility for a more granular data ...
- 1,066
7
votes
1
answer
709
views
DBCC CHECKTABLE taking 15+ minutes to run on an empty table
I have a database where DBCC CHECKTABLE on a number of small or empty tables taking over 15 minutes to run. When it finishes there are no failures or errors. The performance on everything else on ...
- 359
1
vote
1
answer
735
views
Why does DBCC CHECKTABLE WITH TABLERESULTS only report Error 8990 on corrupt tables?
I have a production VLDB that I'm using Paul Randal's guidance on to spread DBCC CHECKDB workload over a week. I'm logging the results of DBCC CHECKTABLE WITH TABLERESULTS and DBCC CHECKALLOC WITH ...
- 3,538
2
votes
0
answers
1k
views
DBCC TABLE CHECK command won't stop
We have a SQL Server 2014 with 140 user databases, each of which have approx. 180 tables.
A maintenance plan was scheduled for once a week but it was discovered that the Check Database Integrity (DBCC ...
- 21
6
votes
1
answer
221
views
Table with persisted computed CLR originated data marked with has_unchecked_assembly_data = 1, but DBCC CHECKTABLE does not unset this same flag
We have an OrderLines table with columns:
Quantity int not null
QtyCancelled int not null
QtyBackorder int not null
QtyPicking int not null
QtyPacking int not null
QtyShiped int not null
with ...
- 141
2
votes
1
answer
360
views
VLDB - Create SQL DB Snapshot And Run Granular DBCC CHECKDB Commands
I have a 25TB db (SQL2008 Enterprise SP4) that appears to not have had CHECKDB run on it in production. No idea if it was run against a restored backup somewhere at sometime. Right now I don't have ...
