I have a SQL Database (150 gb), Some table are corrupted. I ran the command DBCC CHECKTABLE for 1 table the most important table in my system, but this command delays 50 hours and still running. Is there something I can do to do it faster? what else can I do?
I have a SQL Database (150 gb), Some table are corrupted. I ran the command DBCC CHECKTABLE for 1 table the most important table in my system, but this command delays 50 hours and still running. Is there something I can do to do it faster? what else can I do?
What version of SQL Server? You can specify physical only which will reduce the overhead.
------------------------ Future guru in the making.
It's probably doing a 'deep-dive' check - its found some corruption and its going back to work out exactly what the corruption is. Is there any disk/cpu activity?
DBCC CHECKTABLE
Posted - 09/03/2007 : 19:58:44
