Microsoft recommends running DBCC CheckDB, NewAlloc, CheckCatalog and TextAll before or after dumping the database but in order ensure no false error messages are generated you must stop all others from making changes to the database. These procedures can run several hours on large databases so this is a big problem in a 24 x 7 operation.
Does anyone know what SQL 7.0 will do about this?
