I have two SQL servers, server A and server B running SQL Server 2008 R2 Standard. Can I setup a third server that will be a mirror for both server A and server B? I can't seem to find any documentation stating that a many-to-one mirroring is allowed or possible.
Asked
Active
Viewed 103 times
1 Answers
1
Yes, this is possible. Mirroring occurs at the database level. A single SQL server instance can receive mirrors from as many other SQL servers as you want.

longneck
- 23,082
- 4
- 52
- 86