Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL 2000 Replication (Merge or Transactional)

Status
Not open for further replies.

Bsmithx0

IS-IT--Management
Aug 23, 2001
8
US
I have two SQL servers running Windows NT4.
SQL1 is primary
SQL2 is backup

I need two way replication real-time (immediate updating). I know I could make SQL1 the publisher/distributor and the other a subscriber. However, we may need to take SQL1 publisher/distributor offline for maintenance or whatever the case may be. Therefore, I need SQL2 subscriber to become the publisher so it can update SQL1 when it comes back online..

I was looking between merge and transactional replication, but wasnt sure if I am going in the right direction. I dont want to get into clustering, unless that is the only way. Can anyone help me with this? I would greatly appreciate it!!

Thanks

Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top