smtzac (7/16/2014)
My Database mirroring went to suspended mode and log kept growing bigger. Now I am trying to remove mirroring and configure again.After do 'remove' mirroring there will be a restoring mode database on mirror server. in order to configure mirroring again i have to apply T log backup from principle database to restoring database to keep up to date.
My question is , how do I know what is the first T log backup to restore to the mirror server database??
Immediately after you break the mirror the databases should be in sync. Just restore any logs taken since the session was removed. Logs that arent applicable will be skipped 😉
Incidentally why are you removing the mirror session, find out why mirroring was supended and resume the session
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉