個人檔案Blogs部落格清單 工具 說明
    3月8日

    Database Mirroring

    What is mirroring?

     

    Mirroring constantly synchronizes the transaction log of a mirror server with the transaction log of a principal server. The synchronization can be either synchronal to enable high availability, or asynchronal to enable high performance.

    If set to high availability, a witness server is required. this can be either the principal server itself, or a 3rd server. If a 3rd server is chosen, this ensures more security in case of a failure.

    To configure mirroring, the mirror server must restore a backup of the principal with NORECOVERY mode. Thus you cannot access the mirror database directly, since it remains in recovery mode. But you can create a snapshot of the mirror to read data. Also, the database must set to full recovery mode. (Note: if you want to have a full working copy of a database, then log shipping or replication is your choice over mirroring)

    Mirroring requires endpoints (TCP or HTTP) for the principal, the witness and the mirror server. The endpoints are configured automatically, when you create mirroring in the properties options of the database.

    The main purpose for mirroring however is to have a high available backup in case of an error of the principal server.  In High Availability mode, a failover is automatically performed to the mirror, when a failure occurs on the principal. Otherwise you need to launch a failover manually:

    ALTER DATABASE <mirror_database> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    回應

    請稍候...
    很抱歉,您輸入的回應過長。請縮短您的回應。
    您尚未輸入內容,請再試一次。
    很抱歉,目前無法新增您的回應,請稍後再試。
    若要新增回應,您的父母必須先給您權限。要求權限
    您的家長已關閉回應功能。
    很抱歉,目前無法刪除您的回應,請稍後再試。
    您已超過每日回應上限次數,請於 24 小時後再試一次。
    由於系統顯示您可能傳送垃圾郵件給其他使用者,因此您帳號中的回應功能已遭停用。 如果您認為自己帳號遭錯誤停用,請連絡 Windows Live 支援
    請完成下列安全檢查,以完成回應。
    您輸入的安全檢查字元必須與圖片或音訊中的字元相符。

    若要新增回應,請以您的 Windows Live ID 登入 (若您使用 Hotmail、Messenger 或 Xbox LIVE,則您已擁有 Windows Live ID)。登入


    沒有 Windows Live ID?註冊

    引用通告

    此內容的引用通告是:
    http://thomasgerber.spaces.live.com/blog/cns!58B30559C82E269C!696.trak
    引述這則內容的部落格