June 16, 2015 at 9:44 am
Hi,
We have a maintenance plan that reorganize all indexes in a database.
We disabled one of the index on one table this job failed.
How to set up to the maintenance plan to without failing to ignore the reorganizing of disabled indexes?
June 16, 2015 at 9:57 am
ramana3327 (6/16/2015)
Hi,We have a maintenance plan that reorganize all indexes in a database.
We disabled one of the index on one table this job failed.
How to set up to the maintenance plan to without failing to ignore the reorganizing of disabled indexes?
My first answer has to be to not use maintenance plans. They're a brute-force approach that reorganizes everything whether it needs it or not.
If that's not an option for you, I suppose you always have the option of scripting the index you no longer want and then dropping it. If it turns out you need it again, you can recreate it from the SQL you saved. I have to tell you that I don't like this approach. It's better to simply not use maintenance plans to begin with.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply