Server Fault Asked by Walter Zydhek on February 3, 2021
I have a very large database (233GB), and running DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS is taking WAY too long (over 15 hours). There are a lot of indexes on a table that I would rather have removed, but cannot remove the table until the database is back up and running. Each index is taking AT LEAST 2 hours to check. Is there a way to run CHECKDB with both REPAIR_ALLOW_DATA_LOSS AND NOINDEX?
When you run DBCC CHEKDB with NOINDEX then, it skips indexes completely. NOINDEX does not affect system tables because integrity checks are always performed on system table indexes.
Check this reference.
Answered by Priyanka on February 3, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP