Wednesday, March 7, 2012

Data Base Mirroring in SQL server 2005 Express Edition

HI,

Does SQL server 2005 Express Edition or

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

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.

|||It answers to my question. Thank you.

No comments:

Post a Comment