locked
SQL 2008 R2 Mirroring RRS feed

  • Question

  • Dear All,

    We are planning for DR site on VM. Currently we have Physical servers. I have some queries hope to get some help from this forum.

    1) How can we synchronize data between Physical server and Virtual Server?

    2) We are planning to use SQL2008 R2 Mirroring for SQL server data synchronization between two servers one is the physical DB server and second will be the DR VM DB server is this right approach for DB server data synchronization ?

    3) What will be the license cost and details if we implement SQL 2008 R2 mirroring.

    I know that Enterprise Edition priceing depends upon cores of machines. Do i need seperate Licence for SQL 2008 mirroring on two machines.

    Thanks

    Adeel Imtiaz


    Adeel Imtiaz

    Monday, July 2, 2012 3:28 AM

Answers

  • A server is a server is a server. The purpose of virtualization is to abstract the server from the physical hardware. Treat your virtual servers as you would your physical servers.

    1. You can synchronize your servers with:

    • Replication
    • Log shipping
    • Mirroring
    • Failover clustering

    2. It is OK to use mirroring for DR.

    3. You don't need extra licence, if you are using the server only for mirroring and not reporting.


    • Proposed as answer by JamesYi Wednesday, July 4, 2012 2:49 AM
    • Marked as answer by JamesYi Thursday, July 5, 2012 2:27 AM
    Monday, July 2, 2012 6:12 AM
  • Hi,

    By reading the licence document, Please note below:

    When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information held in another server that fails. A passive server does not need a license, provided that the number of processors in the passive server is equal or less than those of the active server. The passive server can take the duties of the active server for 30 days. Afterward, it must be licensed accordingly.

    Regards,
    James

    • Proposed as answer by JamesYi Wednesday, July 4, 2012 2:49 AM
    • Marked as answer by JamesYi Thursday, July 5, 2012 2:27 AM
    Monday, July 2, 2012 7:53 AM

All replies

  • A server is a server is a server. The purpose of virtualization is to abstract the server from the physical hardware. Treat your virtual servers as you would your physical servers.

    1. You can synchronize your servers with:

    • Replication
    • Log shipping
    • Mirroring
    • Failover clustering

    2. It is OK to use mirroring for DR.

    3. You don't need extra licence, if you are using the server only for mirroring and not reporting.


    • Proposed as answer by JamesYi Wednesday, July 4, 2012 2:49 AM
    • Marked as answer by JamesYi Thursday, July 5, 2012 2:27 AM
    Monday, July 2, 2012 6:12 AM
  • Hi,

    By reading the licence document, Please note below:

    When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information held in another server that fails. A passive server does not need a license, provided that the number of processors in the passive server is equal or less than those of the active server. The passive server can take the duties of the active server for 30 days. Afterward, it must be licensed accordingly.

    Regards,
    James

    • Proposed as answer by JamesYi Wednesday, July 4, 2012 2:49 AM
    • Marked as answer by JamesYi Thursday, July 5, 2012 2:27 AM
    Monday, July 2, 2012 7:53 AM