Hi There
I have checked CHECKDB syntax in BOL, i just want to be sure.
In there no way to run CHECKDB on a user database and exclude certain tables, in SS2000.
I have 2 really huge tables , over a billion rows. Nightly i want to run CHECKDB on the database but i do NOT want CHECKTABLE run on these 2 tables as it takes hours.
Or is my only option to instead of running CHECKDB, writing a script that loops through user tables excluding these and running CHECKTABLE. If this is my only option can it be done with a cursor looping through user tables and running CHECKTABLE on each one?
Thanx
Your only option is to run CHECKTABLE with the specific tables. CHECKDB doesn't have any option to filter tables.
No comments:
Post a Comment