July 16, 2014 at 8:49 am
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??
July 16, 2014 at 1:36 pm
I guess you have to remove the mirroring and bring the database online or do as below
RESTORE DATABASE AdventureWorks2012
WITH RECOVERY
If the database is in restoring mode, you cannot run query against it. After the database is active you have to reconfigure the mirroring again from scratch by taking Full backup, restore with no recovery, take log backup- restore on mirror server with no recovery and enable mirroring as you have done initially.
July 17, 2014 at 3:49 am
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" 😉
July 17, 2014 at 10:34 am
@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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply