Showing posts with label virtual. Show all posts
Showing posts with label virtual. Show all posts

Friday, March 9, 2012

Replication of SQL Server In Clustered Environment

We are running 2 SQL Server and both run in failover clustered Environment.
The Problem is now we need to Replicate a Database from one Virtual SQL Sever to the other.

The Second one (clusterd environment)is stroing their database localy while the First One (clustered environment)is storing database in a shared storage.
Note that Both Server are used for sperate purpose , but we now need to set replication on the Other Clustered Setup for Reporting Purpose.

Will it work if we configure replication from One SQL Server Clustered Setup to the Other Clstered Setup.
If yes, then please let me know how it can be done ?

Thanks

Setup replication on cluster environment is no different than non-cluster environment. Remeber to use SQL Server virtual server name instead of a particular node name, also you need make sure snapshot folder is in the shared storage (doesn't depends on a particular node).

Thanks,

Zhiqiang Feng

Tuesday, February 21, 2012

Replication in cluster environment problem

1) I have the Active/Passive cluster environment (using Microsoft cluster service).
2) SQL2000 is installed on the cluster (Virtual instance).
3) Virtual instance of SQL Server is used as Publisher in Transactional replication with updatable subscribers.
4) Subscribers are passing updates to subscriber using MSMQ
5) The problem is : after I establish replication , the Queue Agent fails with following error (Failed to initiate search for MSMQs)Did you define your MSMQ for your queue agent? My guess is not. That's why you got the error.|||I have defined MSMQ resource at "Cluster Managager".
The settings that i was used were taken from microsoft article.
MSMQ have dependeny the same "Network name" as SQL Server.
So if the question "Did you define your MSMQ for your queue agent"
is about that , the answer is yes.
Probably i have not understood your question.