Thank you for the response and I do Agree, I know in principle it is not possible but I was hoping for a work around. I know we could govern...

I have change the db option to bulk- logged , made a full back up remove inactive entries, clear all trns, restore the db to the secondary Force restore over...

Also when i make a full back up on my prod do I have to un check the remove inactive entries from transaction log under options?

Hi Gail,

thank you for response and Im sorry for only comming back to you now. just want to clarify the last part, if I created the db in simple then...

your re-index script will also cause yout tlogs to grow.