Database Mirroring Status

• Jonathan Marshall

  SSCrazy

  Points: 2633

  More actions

  June 30, 2011 at 6:23 pm

  #240704

  I have configured database mirroring without a witness successfully or so I believe.

  The mirrored database is showing a state of (Mirror, Synchronized/Restoring) <<< is this what I want ultimately???

  Also are there any other scripts or suggestions as to where the data is being stored or how its being transmitted through TCP endpoints????

  I use the Mirror monitor but any other suggestions that are helpful?

  thanks,

  Jonathan

• Soonyu-163551

  SSC Eights!

  Points: 811

  More actions

  July 4, 2011 at 12:44 am

  #1347639

  "Synchronized/restoring"

  - Database mirroring setup ok

  - Both principal and database mirroring in already synchronized.

  - Database mirroring in restoring mode and user can't be read/write until we failover the principal to mirroring database.

  I also do the below:

  -use sys.database_mirroring to check where server principal and mirroring database located and mirroring status.

  -use sp_dbmmonitorresults to get unsent log and redo log information of database mirroring

• Jonathan Marshall

  SSCrazy

  Points: 2633

  More actions

  July 4, 2011 at 1:01 pm

  #1347998

  SSC-Enthusiastic thank you that is a great help.

  Will use and follow up with you.

  Jonathan

• kapfundestanley

  SSCertifiable

  Points: 5637

  More actions

  July 8, 2011 at 9:11 am

  #1350408

  For me principal and mirroring are synchronized.Mirroring monitor fine at mirror but showing failure to connect at the principal.

  “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris