locked
Data Base Mirroring in SQL server 2005 Express Edition RRS feed

  • Question

  • HI,

     Does SQL server 2005 Express Edition or

     Does SQL server 2005 Express Edition Sp1 supports Data base Mirroring?

    Tuesday, January 16, 2007 6:31 AM

Answers

  • Here is direct quote from BOL,

    http://msdn2.microsoft.com/en-us/library/ms188712.aspx

    Before you use the Mirroring page to configure database mirroring, ensure that the following requirements have been met:

    • The principal and mirror server instances must be running the same edition of SQL Server-either Standard Edition or Enterprise Edition. Also, we strongly recommend that they run on comparable systems that can handle identical workloads.
      Note:
      The witness server instance can run on SQL Server Standard Edition, Enterprise Edition, Workgroup Edition, or Express Edition.

    So, the answer is no. Unless you use it as witness server.

    Gary (MSFT)

    Wednesday, January 17, 2007 12:14 AM

All replies

  • Here is direct quote from BOL,

    http://msdn2.microsoft.com/en-us/library/ms188712.aspx

    Before you use the Mirroring page to configure database mirroring, ensure that the following requirements have been met:

    • The principal and mirror server instances must be running the same edition of SQL Server-either Standard Edition or Enterprise Edition. Also, we strongly recommend that they run on comparable systems that can handle identical workloads.
      Note:
      The witness server instance can run on SQL Server Standard Edition, Enterprise Edition, Workgroup Edition, or Express Edition.

    So, the answer is no. Unless you use it as witness server.

    Gary (MSFT)

    Wednesday, January 17, 2007 12:14 AM
  • It answers to my question. Thank you.
    Wednesday, January 17, 2007 5:44 AM