alter index with simple recovery mode vs full recovery
Posted on 2011-10-30
How long usually it takes if I run reindex on 400GB db size under simple recovery compare to full recovery ? currently with full recovery it takes a lot of space and always cause the reindex job terminated half way.
So If I change to simple mode-run reindex, after reindex complete change to full recovery mode, again what will be happens with our point in time recovery ? Let says reindex job run under simple mode takes 4 hours to complete 1PM-5PM? Can I roll forward the transaction log backup which I set back to full recovery mode at 6PM ?