[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference decwet::winnt-clusters

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

600.0. "SQL replication on CLUSTER" by DEKVC::JAEYONGPARK () Thu Feb 06 1997 05:48


	Hi,

	I have a customer who have many branch offices running WNT AlphaServer.
        Now, he is using MS SQL replication between head office and branch 
        offices via extended LAN.(The no. of server is 21.) 
        He wants to migrate current all system to cluster environment.

	I have some qustions :

	1) Does Windows NT Cluster v1.1 support SQL replication?
	2) If not, when or which version?
	3) Are there any other recommendations or additional s/w? 

	
	Replication issues are very important for my biz.

        Hope to reply.

        Thanks,

        JY Park / DEK

T.R	Title	User	Personal Name	Date	Lines
600.1		GUIDUK::HEALY	Alan Healy @ZSO	`Tue Feb 11 1997 00:14`	14
	I can't answer whether it will be officially supported. But due to the complexity of replication and the fact that it was designed without clusters in mind, I wouldn't expect it to work, except under very limited conditions. Replication actually involves 4 databases: the Publishing database, the Subscribing database, the Distribution database, and the 'msdb' (scheduling) database. All of these have to be in sync for replication to work correctly. Maybe if I can get a test cluster set up I will try it... Al
600.2	Cluster with replication	NETRIX::"davidliu@mail.dec.com"	David Liu	`Wed Feb 12 1997 07:42`	14
	I have tried to set up the Replication on NT Cluster 1.0SP1 , but I have got a Error Message: "Error 15378: [SQL Server] No Server may list more than one fallback server in its own sysservers table. Aborting this procedure" When I select "Intall Replication Publishing" from SQL Enterprise Manager. Anyone have idea about that? Thanks! David Liu [Posted by WWW Notes gateway]
600.3	???	GUIDUK::HEALY	Alan Healy @ZSO	`Thu Feb 13 1997 15:27`	11
	I'm surprised that Replication would try to install a fallback server. Were you defining a Remote Distributor? Entries are needed in sysservers for any other servers that may need to log in to this server, such as a Remote Distributor. However, I wouldn't think they would be Fallback Servers. If you were setting up a Remote Distributor, was it the other clsuter server? Clusters sets the 'rpc' and 'fallback' bits in the server status field in sysservers. I wonder if replication is getting confused by this. Al
600.4	Possible SQL Bug...	GUIDUK::HEALY	Alan Healy @ZSO	`Thu Feb 13 1997 16:54`	5
	Well, I looked at some of the system stored procedures used in replication and found what I think is a bug in SQL server which I have forwarded to the engineers. Al
600.5	Software Specialists	NETRIX::"davidliu@mail.dec.com"	David Liu	`Mon Feb 17 1997 05:22`	8
	Please forward me the info if you get response from the Engineer. Thanks a lot. Best Regards, David Liu [Posted by WWW Notes gateway]
600.6		NETRIX::"davidliu@mail.dec.com"	David Liu	`Mon Feb 17 1997 05:25`	8
	>Clusters sets the 'rpc' and 'fallback' bits in the server status field >in sysservers. I wonder if replication is getting confused by this. It looks like replication is checking the sysservers table during the installation of the distribution service. Best Regards, David Liu [Posted by WWW Notes gateway]