locked
Require Checklist Details : Mirroring Setup RRS feed

  • Question

  • Hello

     I need checklist details before i start implememting mirroring setup ,will be very much helpful to avoid any confusion .
     
    Regards
     Rithu

    Sunday, November 29, 2009 6:23 PM

Answers

  • Hi ,                                                                           

    If your question is about Pre-requisites  of  mirroring setup  than please find the below checklist details and refer the MSDN links provided below . This were handy at my instance . 

    Checklist details

    Name of the Principal Server

    Name of the Mirror Server

    Name of the Witness Server

    Mirroring endpoint name for Principal server

    Mirroring endpoint name for Mirror server

    Mirroring endpoint name for Witness server

    Endpoint Port number for Principal server

    Endpoint Port number for Mirror server

    Endpoint Port number for Witness server

    Operating mode

    Principal, Witness & Mirror server domain name

    Name of the database to be mirrored

    Check whether the  latest SQL Server Service pack applied

    copy all jobs, logins, SSIS packages, server configuration from Principal server to the mirror server

    Fully qualified server name for Principal,Mirror&Witness

    perform full and log database backups of the principal server database?

     

    http://msdn.microsoft.com/en-us/library/ms366349.aspx : Prerequisites, Restrictions, and Recommendations for Database Mirroring
    http://msdn.microsoft.com/en-us/library/ms366349(SQL.90).aspx : Prerequisites and Recommendations for Database Mirroring

    ----------------------------
    Thanks,Suhas V

    • Marked as answer by RithuVertha Monday, November 30, 2009 2:11 PM
    Sunday, November 29, 2009 8:56 PM
  • 1.     The principal database and the mirror database should be on separate physical hardware, and ideally, in different physical locations.

    2.     The witness server should be on separate physical hardware, and be on a separate network (best if at a third location).

    3.     Initial database mirroring setup should be done during less busy times, as the setup process can negatively affect performance of the production database being mirrored.

    4.     Use high availability mode whenever possible, and high performance mode only when required.

    5.     While a fast connection is not required between mirrored servers, the faster the connection, and the better quality the connection, the better.

    6.     You will want to optimize the performance of the mirrored database as much as possible to reduce the overhead caused by the mirroring process itself.

    7.     Thoroughly test database mirroring before putting it into production.

    8.     Monitor database mirroring daily to ensure that it is working properly, and is meeting performance goals.

    9.     Develop a formal operational and recovery procedure (and document) to support mirroring. Periodically test the failover process to ensure that it works.

    10.  Make sure the principal and mirror SQL SERVICES runs under the same domain account.

    11.  Database should be in full recovery mode.

    12.  Database mirroring Endpoint should be started.


    Thanks, Leks
    • Marked as answer by RithuVertha Monday, November 30, 2009 2:10 PM
    Monday, November 30, 2009 1:21 AM
    Answerer
  • Make sure that the mirror server has the exact same jobs, logins,  disk partitions, disk space, server configuration, etc 

    Configure the mirror server with the server settings exactly as the principal server was configured. You may do this by running and comparing the output of ―Exec SP_Configure‖ system stored procedure on both principal and mirror servers.

    -----------------------
    Thanks,Suhas V
    • Marked as answer by RithuVertha Monday, November 30, 2009 2:10 PM
    Monday, November 30, 2009 12:53 PM

All replies

  • Hi ,                                                                           

    If your question is about Pre-requisites  of  mirroring setup  than please find the below checklist details and refer the MSDN links provided below . This were handy at my instance . 

    Checklist details

    Name of the Principal Server

    Name of the Mirror Server

    Name of the Witness Server

    Mirroring endpoint name for Principal server

    Mirroring endpoint name for Mirror server

    Mirroring endpoint name for Witness server

    Endpoint Port number for Principal server

    Endpoint Port number for Mirror server

    Endpoint Port number for Witness server

    Operating mode

    Principal, Witness & Mirror server domain name

    Name of the database to be mirrored

    Check whether the  latest SQL Server Service pack applied

    copy all jobs, logins, SSIS packages, server configuration from Principal server to the mirror server

    Fully qualified server name for Principal,Mirror&Witness

    perform full and log database backups of the principal server database?

     

    http://msdn.microsoft.com/en-us/library/ms366349.aspx : Prerequisites, Restrictions, and Recommendations for Database Mirroring
    http://msdn.microsoft.com/en-us/library/ms366349(SQL.90).aspx : Prerequisites and Recommendations for Database Mirroring

    ----------------------------
    Thanks,Suhas V

    • Marked as answer by RithuVertha Monday, November 30, 2009 2:11 PM
    Sunday, November 29, 2009 8:56 PM
  • 1.     The principal database and the mirror database should be on separate physical hardware, and ideally, in different physical locations.

    2.     The witness server should be on separate physical hardware, and be on a separate network (best if at a third location).

    3.     Initial database mirroring setup should be done during less busy times, as the setup process can negatively affect performance of the production database being mirrored.

    4.     Use high availability mode whenever possible, and high performance mode only when required.

    5.     While a fast connection is not required between mirrored servers, the faster the connection, and the better quality the connection, the better.

    6.     You will want to optimize the performance of the mirrored database as much as possible to reduce the overhead caused by the mirroring process itself.

    7.     Thoroughly test database mirroring before putting it into production.

    8.     Monitor database mirroring daily to ensure that it is working properly, and is meeting performance goals.

    9.     Develop a formal operational and recovery procedure (and document) to support mirroring. Periodically test the failover process to ensure that it works.

    10.  Make sure the principal and mirror SQL SERVICES runs under the same domain account.

    11.  Database should be in full recovery mode.

    12.  Database mirroring Endpoint should be started.


    Thanks, Leks
    • Marked as answer by RithuVertha Monday, November 30, 2009 2:10 PM
    Monday, November 30, 2009 1:21 AM
    Answerer
  • Make sure that the mirror server has the exact same jobs, logins,  disk partitions, disk space, server configuration, etc 

    Configure the mirror server with the server settings exactly as the principal server was configured. You may do this by running and comparing the output of ―Exec SP_Configure‖ system stored procedure on both principal and mirror servers.

    -----------------------
    Thanks,Suhas V
    • Marked as answer by RithuVertha Monday, November 30, 2009 2:10 PM
    Monday, November 30, 2009 12:53 PM
  • Thanks Much for both of you .
    Monday, November 30, 2009 2:09 PM