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 102 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.
![](../../users/profiles/15028.webp)
longneck
- 22,793
- 4
- 50
- 84