Showing posts with label repair_rebuild. Show all posts
Showing posts with label repair_rebuild. Show all posts

Monday, March 12, 2012

How long does dbcc checkdb with Repair_rebuild option take?

The database is rather small. The dbcc checkdb without any option took just less than 1 min. But the dbcc checkdb with
repair_rebuild took almost 2 hours and is still running. Is it usual? Should I let it continue
Thanks.depends how much data and howmany indexes you have
did you get errors when you ran check db? also could have just run dbcc checkdb with repair_fast option and do repair_rebuild option at the weekend.(repair_rebuild re-creates indexes and more time concuming!)

How long does dbcc checkdb with Repair_rebuild option take?

The database is rather small. The dbcc checkdb without any option took just
less than 1 min. But the dbcc checkdb with
repair_rebuild took almost 2 hours and is still running. Is it usual? Should
I let it continue?
Thanks.depends how much data and howmany indexes you have?
did you get errors when you ran check db? also could have just run dbcc chec
kdb with repair_fast option and do repair_rebuild option at the weekend.(rep
air_rebuild re-creates indexes and more time concuming!)