Sql server 2k Transactional replication URGENT

• spaliwal

  SSChasing Mays

  Points: 604

  More actions

  September 19, 2003 at 7:51 am

  #82594

  Hi Experts,

  I have to implement Transsactional Push type replication on my OLTP database to seperate out reporting database as a subscriber.Also we need to apply frequent ddls as part of build and patch on the source (publisher) database, and replication dosent allow it.

  I need step by step procedure to setup and ofcourse the solution for the following issues -

  1. Database changes DDLs apply on the publisher and subscriber.

  2. Notification when problem comes and action to restart the replication.

  3. Any hidden issues which i am not considering.

  Pl. let me know any link/url for the same.

  TIA,

  Sheilesh

• philcart

  SSC-Forever

  Points: 47797

  More actions

  September 21, 2003 at 5:45 pm

  #475183

  Take a look over the following,

  http://support.microsoft.com/default.aspx?scid=kb;en-us;324966&Product=sql2k

  http://www.msdn.microsoft.com/library/en-us/dnsql2k/html/sql2k_replperf_tran4.asp?frame=true

  http://msdn.microsoft.com/library/en-us/replsql/replover_694n.asp?frame=true

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface