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 123»»»

How to check mirrored database Expand / Collapse
Author
Message
Posted Wednesday, November 21, 2012 2:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
Dear,

I have implemented database mirroring with automatic failover option. My principal database is a busy one. Now I am not sure that whether the mirror database is receiving data from principal.

How do I check that ?

Please help me.


Regards,
Akbar
Post #1387292
Posted Wednesday, November 21, 2012 2:41 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
Mirrored database can't be accessed at any time. You need to take a Snapshot of mirrored database, then you can query the snapshot (Snapshot option is in only Enterprise Edition).

Also if you use the Mirroring Monitor (in ssms), you can identify whether you mirroring session in sync.
Post #1387306
Posted Wednesday, November 21, 2012 4:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
Actually I am using Standard Edition, so can not create database snapshot.

I went database mirroring monitor and found "Synchronized" from Mirroring State column of both of the server instances.

Does it indicate that data is updated from principal to mirror?
Post #1387338
Posted Wednesday, November 21, 2012 4:20 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
shohelr2003 (11/21/2012)
I went database mirroring monitor and found "Synchronized" from Mirroring State column of both of the server instances.
this would be the first assured and positive impression that data is being mirrored


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1387346
Posted Wednesday, November 21, 2012 4:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
Thank you, so nothing to be worried.
Post #1387361
Posted Wednesday, November 21, 2012 5:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 9:39 PM
Points: 397, Visits: 2,414
shohelr2003 (11/21/2012)
Thank you, so nothing to be worried.


You should also see next to the principal db says "synchronized"

Since you have witness server, I am thinking, you configured with synchronize mode.

Regards,
SueTons.


Regards,
SQLisAwe5oMe.
Post #1387389
Posted Wednesday, November 21, 2012 7:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:53 AM
Points: 6,170, Visits: 13,313
SQLCrazyCertified (11/21/2012)
shohelr2003 (11/21/2012)
Thank you, so nothing to be worried.


You should also see next to the principal db says "synchronized"

Since you have witness server, I am thinking, you configured with synchronize mode.

Regards,
SueTons.

With Standard edition, synchronous is the only option available.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1387435
Posted Wednesday, November 21, 2012 7:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 9:39 PM
Points: 397, Visits: 2,414
Ohk....thanks Perry.....didn't know that.

SueTons.


Regards,
SQLisAwe5oMe.
Post #1387436
Posted Wednesday, November 21, 2012 10:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:53 AM
Points: 6,170, Visits: 13,313
SQLCrazyCertified (11/21/2012)
Ohk....thanks Perry.....didn't know that.

SueTons.

Standard only supports full safety, this translates into synchronous mode


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1387506
Posted Wednesday, November 21, 2012 9:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 2:17 AM
Points: 203, Visits: 499
If I restore database on principal, then what steps should be taken to maintain mirroring? Do I need to do anything on mirror database?

Please help me.
Post #1387680
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse