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!)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment