THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

Comments

 

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.

Regards,

Greg

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

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement