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

sql server mirroring synchronization not happening Expand / Collapse
Author
Message
Posted Tuesday, March 5, 2013 11:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 1:15 PM
Points: 3, Visits: 32
Hi all,

I have mirroring setup, Seems to everything fine.But synchronization not happening.i don't understand what was the problem.

Please any one provide solution for this problem.

With,
Bharath.
Post #1427190
Posted Wednesday, March 6, 2013 4:01 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
Sync will take time depending on the number of transactions to be replayed in mirror database, network latency between principal/mirror and disk latency in mirror server.

Monitor it for some time, it will be sync unless you have any serious problem.
Post #1427281
Posted Thursday, March 7, 2013 12:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:21 AM
Points: 2,837, Visits: 3,954
sqldban (3/5/2013)
But synchronization not happening.i don't understand what was the problem.
have you checkedt he statuses of morrored databases ? are they showing ("mirrored synchrnoized restoring...") ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1427807
Posted Wednesday, March 13, 2013 6:27 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:23 PM
Points: 424, Visits: 1,549
Mirror Monitor is your first friend- it provides info on: how long it can take to sync, latest moved transaction, etc. A lot of helpful info
Post #1430702
Posted Wednesday, March 13, 2013 9:48 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Saturday, September 14, 2013 8:05 AM
Points: 101, Visits: 108
Please provide the results for the below query.

SELECT DB_NAME(DATABASE_ID) 'DBNAME',mirroring_state,
mirroring_state_desc,mirroring_role,
mirroring_redo_queue,mirroring_redo_queue_type,*
FROM sys.database_mirroring
WHERE mirroring_guid IS NOT NULL

Regards,
Ram,
MCTS,MCITP
Post #1430729
Posted Thursday, March 14, 2013 8:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 6:13 AM
Points: 307, Visits: 475
How do you know synchronisation is not happening? If in the SMSS the principal shows synchronised and the mirror shows restoring then it should be ok. What does the mirroring monitor show?
Post #1430995
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse