locked
Replication of SQL Server In Clustered Environment RRS feed

  • Question

  • 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

     

    Wednesday, August 9, 2006 9:19 AM

Answers

  • 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

    Wednesday, August 9, 2006 6:16 PM