@muthyala_51: I did remove mirroring and the database (on mirror server) is in restoring mode).

My question is How do I find out the next Transaction log backup file to apply to sync mirroring again.

Another words is there any way I can find out what was the last log file applied to the database so I can apply next one to sync mirroring again.

@perry Whittle: How do I find out the next log file?? the database is in restoring mode on mirror server and log backup is being taken every 3 hours.Trying to find out the way to find what was the last log applied and what is the next one. Do you know any query?

Thank you both for taking time to reply.