THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Run database checks but omit large tables or filegroups - New option in Ola Hallengren's Scripts

Published Monday, July 2, 2012 6:02 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Gavin Morris said:

Hi Greg,

We have this problem - some of our customer databases have ~50GB of useful structured data and ~400GB of blobs. Can you point me at anything on the considerations for skipping the check on these tables?

July 9, 2012 8:46 PM

Greg Low said:

Hi Gavin,

That's exactly what Ola's options do. You can specify a list of tables to omit.



July 9, 2012 9:19 PM

Mark Hions said:

Microsoft considers the workaround of multiple CHECKTABLE operations to be "non-onerous", which is a new term to add to my dictionary.

November 29, 2012 2:20 PM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement