Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Re configure mirroring question Expand / Collapse
Author
Message
Posted Wednesday, July 16, 2014 8:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 139, Visits: 498
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??
Post #1593108
Posted Wednesday, July 16, 2014 1:36 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:41 AM
Points: 419, Visits: 2,122
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.
Post #1593273
Posted Thursday, July 17, 2014 3:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:41 PM
Points: 6,760, Visits: 14,413
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"
Post #1593458
Posted Thursday, July 17, 2014 10:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:06 AM
Points: 139, Visits: 498
@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.
Post #1593708
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse