Post reply

Log file grows to hard (from mirrored database)

  • April 6, 2011 at 6:38 am

    #1307972

    C.K.Shaiju (4/6/2011)

    Gail/Ali, Is there any way to restore the data from Mirror to Primary if something happened to primary data?

    The mirror is exactly that. A complete mirror image of the principal. If data is deleted from the principal the log records are shipped across immediately and the data will be deleted from the mirror as well.

    If the principal DB fails completely, the mirror can be brought into an active state and a backup taken to recreate the principal, but mirroring is of no help at all for accidental deletion/modification of data. Unlike log shipping there isn't a built-in delay.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 6, 2011 at 6:44 am

    #1307976

    Ok. Got it, Thanks.

    _____________________________________________
    One ounce of practice is more important than tonnes of dreams

Viewing 2 posts - 16 through 16 (of 16 total)

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