July 2, 2008 at 10:52 am
I had a corrupt file on a 6 terra byte production database, because of which the database would not come back online. I brought up the database in emergency mode "Alter Database Set Emergency" and ran a dbcc checkfilegroup on the filegroup of the corrupt file. The advice was to run a checkdb with repair_allow_data_loss.
The checkdb command is now running for over 48 hours and I have no clue when it will be over. The database size is about 6 TB and has about 800 files (due to partitioning).
Please let me know if you can extrapolate (from your experience) an approximate ETA for this checkDB operation.
Regards
Rupendra
July 2, 2008 at 11:22 pm
The answer is 'it depends'. See the following for a full explanation:
http://www.sqlskills.com/blogs/paul/2007/11/15/CHECKDBFromEveryAngleHowLongWillCHECKDBTakeToRun.aspx
It will take at least as long as your CHECKDB usually takes without specifying repair. Why are you running repair anyway - surely with a partitioned 6TB database, you've got a comprehensive backup strategy?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
July 3, 2008 at 8:45 am
Hi paul plz change ur pic
July 4, 2008 at 1:45 am
Excuse me? Why should I change my picture?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
July 4, 2008 at 7:18 am
Rupendra,
Seeing as your original post was over two days ago, i am intrigued as to whether CHECKDB has finished now?
Matt.
July 5, 2008 at 10:07 am
Matt,
The CHECKDB finished successfully in about 3 days and 16 hours. This was an 8 CPU Windows Server 2003 box (Intel(R) Xenon(R) CPU E5345 @ 2.33 GHz) with 32GB RAM and storage on an EMC SAN. There was no other significant IO or processing going on while the CHECKDB was running.
Regards
Rupendra
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply