Scenario:
Start-up(read every $ counts).
Task: Set-up database mirroring(Asynchronous).
Variables:
- 1 Copy of SQL 2008 STANDARD OEM,
- 1 Copy of SQL 2008 R2 STANDARD
- 2 Dedicated SQL boxes(one is much zippier than the other one, that's why Asynchronous mirroring)
Questions: What is the cheapest way to set-up mirroring?
Options:
- Mirroring 2008 to 2008 r2 wont work, right ?
- 2 Copies of SQL 2008 R2 STANDARD seems to be won't work as well.
- will SQL 2008 R2 STANDARD(Principal) and SQL 2008 R2 Enterprise(Mirror) work ?
- 2 Enterprise editions should work ?
