Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication across 2 sql servers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-20 : 08:20:53
stephen writes "I am trying to setup 2 sql servers to have an exact copy of a database on both servers.

heatsrv1 is the publisher
heatsrv2 is the subscriber.

i want any new data and tables copied across to heatsrv2, i am unable to get this to work 100%.

i am unsure if i am doing something wrong.

Do you have a idiots guide on how to achieve this.

Regards

Steve"

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-02-20 : 10:49:44
What kind of replication are you trying to set up?
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-02-20 : 20:30:01
you can refer to books online, replication

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -