June 30, 2011 at 6:23 pm
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
July 4, 2011 at 12:44 am
"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
July 4, 2011 at 1:01 pm
SSC-Enthusiastic thank you that is a great help.
Will use and follow up with you.
Jonathan
July 8, 2011 at 9:11 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply