All Questions
Tagged with dbcc-checkdb dbcc-checktable
5 questions
4
votes
1
answer
276
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
3
votes
2
answers
2k
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 ...
- 83
0
votes
1
answer
593
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 ...
- 240
0
votes
1
answer
215
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,127
2
votes
1
answer
414
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 ...
