Hi Paresh,

I like your solution but again i am bit hasy in applying in production before testing it local.

Are you sure log shipping will not affected after this process because my production database is very large and it takes quite long time to backup and restore on secondary server.