[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | WinNT-Clusters |
| Notice: | Info directories moved to DECWET::SHARE1$:[NT_CLSTR] |
| Moderator: | DECWET::CAPPELLOF |
|
| Created: | Thu Oct 19 1995 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 863 |
| Total number of notes: | 3478 |
593.0. "Replication of shared database to local disk" by 22740::TERENCELEUNG () Mon Feb 03 1997 03:28
Please advise the following configuration is vaild.
SQL SERVER A ------- SHARED DATABASE ------ SQL SERVER B
(PRIMARY) | | (FAILOVER)
| |
| Replication |
| |
+---------------> LOCAL DATABASE
Server A & B : WNT 3.51 SP5, WNT CLUSTER 1.0A SP1, SQL SERVER 6.5
Local Database is a Replication of Shared Database.
At the same time, some clients access Shared Database via Server A,
some other clients access (read-only) Local Database via Server B.
A customer set up this configuration and demonstrated it worked, until
the failover. After failing over from Server A to Server B, both
Shared and Local Databases cannot be accessed via Server B.
However, if the local database is not a replication of shared database.
The failover works.
Any hints ?
Thanks in advance.
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 593.1 | | GUIDUK::HEALY | Alan Healy @ZSO | Mon Feb 10 1997 20:40 | 10 |
| This configuration is unsupported on V1.0A (One SQL Server at a time is
allowed). V1.1 will support databases on both servers, but I would not
give it much chance of working even then. I doubt whether the
replication code in SQL Server understands clusters.
I believe that the replication code would see it as a different
database when it's on the backup server. If you had replication set up
on the backup server as well as the primary, things could get seriously
out of sync.
|