March 5, 2013 at 11:58 pm
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.
March 6, 2013 at 4:01 am
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.
March 7, 2013 at 12:23 am
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;-)
March 13, 2013 at 6:27 pm
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
March 13, 2013 at 9:48 pm
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
March 14, 2013 at 8:15 am
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?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply