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

Use the Mirror db for reporting Expand / Collapse
Author
Message
Posted Wednesday, March 19, 2014 2:36 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 11, 2014 11:02 AM
Points: 83, Visits: 211
Hi,
I have setup mirroring from serverA to serverB using ServerC as a witness for failover.
When i set up a dummy test db, I am able to query that db on serverB. But when I do the actuall production db, it says restore/sync mode.
What am I doing wrong?

I am using the 2008r2 enterprise version for all of the severs.
thanks
Post #1552797
Posted Wednesday, March 19, 2014 2:57 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 11, 2014 2:28 PM
Points: 1,194, Visits: 2,219
That's not possible. Mirror DB is not accessible as it is. May be dummy test db was primary DB on Server B.
You can't use the Mirror DB directly for reporting. You need to use DB snapshot of the Mirror DB for reporting.

--
SQLBuddy
Post #1552808
Posted Friday, March 21, 2014 9:05 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 12:54 PM
Points: 611, Visits: 439
Please ensure that you have setup the mirroring correctly , restore the Full backup with NORECOVERY .
Post #1553526
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse