3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 1: Introduction 3
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
Many-to-One
In this configuration, one node provides backups for the Virtual SQL
Servers running on the other nodes. In the following example, nodes 1, 2,
and 3 are each hosting a Virtual SQL Server. These virtual servers all use
node 4 as a backup. The instances associated with the Virtual SQL Servers
are all installed on backup node 4.
The following configuration also has one node providing a backup for the
Virtual SQL Servers on other nodes. In this example, the SQL instances
associated with the Virtual SQL Servers all have the same name,
“instance1.”
Node 2
Primary: virtual2
instance2
instance3
Backup: virtual1
instance1
Node 1
Primary: virtual1
instance1
Backup: virtual2
instance2
instance3
Node 2
Primary: virtual2
instance2
Node 1
Primary: virtual1
instance1
Node 3
Primary: virtual3
instance3
Node 4
Backup: virtual1,
virtual2, virtual3
instance1
instance2
instance3
Node 2
Primary: virtual2
instance1
Node 1
Primary: virtual1
instance1
Node 3
Primary: virtual3
instance1
Node 4
Backup: virtual1,
virtual2, virtual3
instance1