1

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.

Alex
  • 38
  • 3

1 Answers1

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
  • 22,793
  • 4
  • 50
  • 84