Browse by Tags

DBCC CHECKDB

Published 14 May 8 5:15 AM | SSQA.net

DBCC CHECKDB checks the logical and physical integrity of all objects in the specified database by performing the following: Runs DBCC CHECKALLOC on the database Runs DBCC CHECKTABLE on every table and view in the database Runs DBCC CHECKCATALOG on the...

Filed under: sql server, dbcc, Database Maintenance

CHECKDB From Every Angle: How long will CHECKDB take to run?

Published 14 November 7 10:22 PM | SSQA.net

This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out...

Filed under: performance, dbcc, disaster recovery, Database Maintenance, CHECKDB From Every Angle, Corruption