CHECKDB (Part 6): Consistency checking options for a VLDB

re: CHECKDB (Part 6): Consistency checking options for a VLDB

simonlid — Mon, 30 Oct 2006 22:21:44 GMT

Congrats on the dive certification, you will love diving in Indonesia. I was there this summer outside Borneo.

Keep up the good posts.

Cheers

SimonLid

Checking Database Consistency in Very Large Databases (VLDB)

Julian Kuiters — Tue, 31 Oct 2006 01:46:53 GMT

Paul Randal who was previously the Lead Developer / Manager for a team working on the SQL Server Storage Engine, has written a short article on the challenges and some options for using DBCC CHECKDB in a VLDB. If you are looking after databases in the

CHECKDB (Part 7): How long will CHECKDB take to run?

SQL Server Storage Engine — Wed, 24 Jan 2007 23:59:43 GMT

This is a question I see every so often and it cropped up again this morning so I'll use it as the subject

PSSUG - Paul Randal via Live Meeting, all naked!

Brian H. Madsen - .Net Powered by Caffeine — Sat, 12 May 2007 16:32:54 GMT

The Perth SQL Server User Group was lucky enough to have Paul Randal , Principal Lead Program Manager

Quick list of VLDB maintenance best practices

SQL Server Storage Engine — Wed, 16 May 2007 17:12:44 GMT

One evening last week I sat down with Kimberly for 5 minutes to come up with a top-of-our heads list

re: CHECKDB (Part 6): Consistency checking options for a VLDB

GregHa — Mon, 18 Jun 2007 22:19:38 GMT

Under the "Use a seperate system" section, would running the CHECKDB on a log shipped database brought on line for this purpose provide the same funtionality as the backup restoration method you described?

re: CHECKDB (Part 6): Consistency checking options for a VLDB

Paul Randal - MSFT — Tue, 19 Jun 2007 01:33:05 GMT

Hi Greg,

Not really - as the log shipping secondary will only be taking log backups from the primary database, not a full database backup. This means that the integrity of all data file pages won't be checked using the method you describe.

Thanks

维护VLDB最佳建议清单之存储篇

鸟儿飞过 — Fri, 10 Aug 2007 02:49:51 GMT

转载、解释一下来自SQL Server Storage Team的VLDB维护建议清单。虽然主题是维护，但相信理解这些对于从事数据库开发的人员来说也有一定价值。

Database Corruption Part 3 :: Differences between CHECKTABLE and CHECKDB

Blogs from Suhas — Thu, 14 May 2009 15:56:18 GMT

In this post, we would have a look at the differences between DBCC CHECKTABLE and DBCC CHECKDB. We would