mirroring

Question

mirroring

reddy.rasimpalli

SSC Veteran

Points: 275
More actions
August 6, 2010 at 7:08 am

#148293

how to access mirror database any one can explain

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

You can not access it directlty as it is set to no-recovery.

You could failover to the mirror and then look at it there , but since it is a mirror it will look exactly like the principal.

Sudeepta SSCommitted Points: 1666 More actions · Answer 2

reddy.rasimpalli (8/6/2010)
how to access mirror database any one can explain

As Steve mentioned, you can not directly access a mirror database, it will not allow any connections. However, you can create a snapshot of the mirror database, can execute some SELECT query on that.

Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly

Harish Vaidyanathan Old Hand Points: 387 More actions · Answer 3

You can create a snapshot of the mirrored DB and run query against the snapshot. You can create snapshot only and only if both the DB principle and mirror are in sync

sqldba4u Hall of Fame Points: 3414 More actions · Answer 4

And, if you want do make it read-write, you need to break the mirroring and as mirror database is in no recovery mode, you need to issue the following command to bring it online.

use master

go

RESTORE DATABASE <database_name> WITH RECOVERY;