I am planning an index rebuild, however my logs are prone to huge overblown sizes.
In fact I was leaning towards doing an intelligent re-indexing, but since the fragmentation levels are greater than 30% I thought I should do a rebuild.
My databases use the full recovery model. Should I change the recovery model to Bulk logged before I do the rebuild later this weekend when there are less transactions happening.
Log shipping is enabled as a DR solution in these databases.
What do you suggest if my latency is quite high? Is there a better DR solution that I should look into?