sql server mirroring synchronization not happening

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » sql server mirroring synchronization not...

sql server mirroring synchronization not happening

Rate Topic

Display Mode

Topic Options

Author

Message

sqldban

Posted Tuesday, March 05, 2013 11:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 21, 2013 1:28 AM
Points: 3, Visits: 28

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 06, 2013 4:01 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 4:26 AM
Points: 300, Visits: 485

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

Bhuvnesh

Posted Thursday, March 07, 2013 12:23 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1427807

Yuri55

Posted Wednesday, March 13, 2013 6:27 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 6:39 PM
Points: 400, Visits: 1,432

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

sankar276

Posted Wednesday, March 13, 2013 9:48 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:05 PM
Points: 99, Visits: 98

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

kevaburg

Posted Thursday, March 14, 2013 8:15 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:00 AM
Points: 159, Visits: 190

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 »

Permissions