asked on

alter index with simple recovery mode vs full recovery

Hi,
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 ?

ASKER CERTIFIED SOLUTION

Anuj

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Qlemo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

GSGDBA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Racim BOUDJAKDJI

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Racim BOUDJAKDJI

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Racim BOUDJAKDJI

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

motioneye

ASKER

I also strongly recommend that you set the SORT_IN_TEMPDB to YES and MAXDOP to all the CPU's when recreating the index: that will speed up things.

Yes I have enable sort in Tempdb , ufortunately we run on Standard Edition so MAXDOP will not be an option to us.