Transactional replication

From: Elvis (Elvis_at_discussions.microsoft.com)
Date: 11/03/04

  • Next message: Thomas Hase: "set -SkipErrors with TSQL or DMO" 
    Date: Wed, 3 Nov 2004 09:24:03 -0800

    Hi,

    I have the following setup, SQL1 and SQL2
    These server are windows 2003 and sql 2000 and both located in different
    offices connected by a 100MB WAN link. I have successfully created
    Transactional replication for failover....If SQL1 the publisher goes down,
    users will be redirected to SQL2 the subscriber....how will users be able to
    update this database (subscriber) and then send those changes back to the
    Publisher...I know merge does this but only SQL1 will be active...SQL2 is
    merely for DR purposes or failover.....Please advise...

    Thanking You
    Elvis

  • Next message: Thomas Hase: "set -SkipErrors with TSQL or DMO"

    Relevant Pages

    • Multi Instance Cluster Question
      ... Its SQL 2000 EE on ... Windows Server 2003 EE ... one ..in my case SQL2.. ... a default instance was named as SQL1. ...
      (microsoft.public.sqlserver.clustering)
    • SQL 2000 transactional replication is generating snapshot every hour
      ... SQL2 subcribed to SQL1, and publisher+distributor for SQL3 ... and at the same time SQL2 is generating a snapshot for every publication it ... 2GB) every hour for every publication. ...
      (microsoft.public.sqlserver.replication)
    • Windows security
      ... I want to back up a database from SQL1 and restore it ... I want mydbowner to have db_owner rights on mydbase on both ... course the login doesn't exist on SQL2. ...
      (microsoft.public.sqlserver.security)
    • Merge result of two queries?
      ... I need to 'fill in the gaps' in the results of SQL1 - notice that it ... SQL2 returns results for all dates, with a forced count of 0. ... How do I construct a query that would pad gaps in SQL1's results with the ... It has removed 452 spam emails to date. ...
      (comp.databases.oracle.misc)
    • RE: Access to a remote SQL server through ISA server
      ... Make a network trace on both sides (SQL1) and (SQL2). ... Use osql.exe connect to the remote server and execute sp_tables. ...
      (microsoft.public.sqlserver.security)