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

Database Mirroring Expand / Collapse
Author
Message
Posted Monday, December 7, 2009 5:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 12:15 PM
Points: 35, Visits: 210
Hi,

I would like to see the updated changes in the mirrored database that the change i made in principal.
so i stopped mirroring. The mirrored database is in norecovery mode.
how can i see the changes in mirrored server. any way to see the data?

Note: Two instances have been created on the same server for db mirroring and implemented mirroring.
Post #829759
Posted Monday, December 7, 2009 5:39 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: 2 days ago @ 5:38 AM
Points: 405, Visits: 1,136
Hi

I would restart your mirroring.

The easiest way to check that the mirror is being updated in to use the sql database mirroring monitor. (this will tell you if the databases are syncing and synchronised.

If you actually want to see that the data exist in the mirror then best thing to do is failover the principle

ALTER DATABASE ????? SET PARTNER FAILOVER



_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #829767
Posted Monday, December 7, 2009 6:24 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 7:32 PM
Points: 700, Visits: 1,029
You can also create a database snapshot on the mirror to avoid failover - if you're on Ent or Dev edition.
Post #829788
Posted Monday, December 7, 2009 6:29 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, December 6, 2012 2:49 PM
Points: 140, Visits: 310
By Stopping mirrorring you will not be able to see the changes.
To see the changes.
1.Make note of the changes you want to see.
2.Failover the mirroring, now you should see the original principal server as mirrored and the mirrored server as principal,synchronising.
3.Check for the changes in the new principal server.

Pavan.
Post #829795
Posted Monday, December 7, 2009 8:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 12:15 PM
Points: 35, Visits: 210
Thanks for the replies...
let me try to do fail over mirroring....

Thank you once again...

Regards,
Chandhini
Post #829909
Posted Monday, December 7, 2009 11:29 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 12:15 PM
Points: 35, Visits: 210
Thank you SQL Expertise..

i tried Mirroring failover to verify the data is updated in mirrored database.
it has come



Post #830439
Posted Saturday, March 31, 2012 4:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 11, 2012 2:18 AM
Points: 10, Visits: 13
Hi,

One of our company client has already configured the mirroring but there is no witness server so i want to confirm if the principle server goes down or damaged then will it changes the mirrored server to principal server?

Thank you.

Post #1276154
Posted Saturday, March 31, 2012 6:26 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 42,479, Visits: 35,547
farrukh635 (3/31/2012)
Hi,

One of our company client has already configured the mirroring but there is no witness server so i want to confirm if the principle server goes down or damaged then will it changes the mirrored server to principal server?


Please don't post the same question in multiple places. No replies to this please. Replies to: http://www.sqlservercentral.com/Forums/Topic1276157-146-1.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1276167
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse