SQL Server 2014 reindex maintenance plans
Posted on 2016-09-07
i have a maintenance plan setup to run a weekly index. Within the maintenance plan i have a rebuild index task and a reorganize index task. I just wanted to ask the experts if it is recommended to do both or if i could just use the rebuild task and not worry about reorganizing index task.
I want to avoid the huge log file that is created when running the reorganizing index task but i don't want to eliminate the reorganizing index task if it is something that will be important.
Also, i should mention that the job that includes reorg and rebuild is failing due to the log file filling up. Maybe i can change settings for the log file to allow a bigger one and then run the job nightly instead of weekly...