Post reply

mirroring

  • August 6, 2010 at 7:08 am

    #148293

    how to access mirror database any one can explain

  • August 6, 2010 at 7:55 am

    #1203523

    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.

  • August 6, 2010 at 8:21 am

    #1203549

    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

  • August 6, 2010 at 8:55 pm

    #1203823

    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

  • August 12, 2010 at 6:36 am

    #1205951

    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;

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

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