MIrroring Access details

  • Hi All,

    I am using live database & my conpany requesting for MIRRORING database.....

    If i start for mirroring the users will access the database or not?

    Please explain me..... littel bit confuse...

    Regards

    Satish

  • saidapur_satish (11/16/2010)


    Hi All,

    I am using live database & my conpany requesting for MIRRORING database.....

    If i start for mirroring the users will access the database or not?

    Please explain me..... littel bit confuse...

    Regards

    Satish

    You need to refer books online for concepts of mirroring.

    Your principal database will be accessible the same way it was before mirroring setup.

    Your mirror database will be in restoring mode and hence not accessible. If you need to leverage mirror for reports, you need to create database snapshots on mirror (Enterprise edition only)



    Pradeep Singh

  • Hi Pradeep,

    Not a problem for MIRRORING, i want to know if i doing mirroring in live server users will access the data or not...................

    Thanks & Regards

    Satish

  • Users will not be impacted on principal server while setting up mirroring.



    Pradeep Singh

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

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