SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Re configure mirroring question


Re configure mirroring question

Author
Message
Tac11
Tac11
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1523 Visits: 1159
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??
muth_51
muth_51
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2555 Visits: 2928
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.
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)SSC Guru (54K reputation)

Group: General Forum Members
Points: 54301 Visits: 17684
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" ;-)
Tac11
Tac11
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1523 Visits: 1159
@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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search