Active Directory and SQL Replication -- sql server replication

tiaatrv NO[at]SPAM aol.com
8/7/2003 10:24:05 PM

Thanks in advance for any help you guys can provide...

This is the setup I have:
a) SQL Server 2000 Standard running on Windows 2000 Server at multiple co-lo
sites
b) No VPN between the sites

I would like to be able to do replication between the sites so if a value is
changed at any site it is replicated to all of the others (that's not the issue
being addressed here, just background info).

What do I need to setup in terms of a domain for this to happen? What's the
simplest solution? I don't have to worry about users that need to login,
etc... Just whatever SQL Server needs to replicate. Can I make the SQL Servers
DCs? Any help or pointing me in the right direction would be greatly
appreciated!

deejaycez NO[at]SPAM aol.com
8/8/2003 9:24:17 AM

I would recommend XOSoft's WANsync SQL
(http://www.xosoft.com/products/WANSyncSQL.htm) to automatically
replicate your SQL 2000 server over WAN. 3.5 version of the software
journals every database update and sys events, so if your databases
ever suffer from any kind of hardware failures, data corruption or
disaster you can restore your secondary servers in minutes without
losing data or disrupting workflow. Let me know if you have any
questions.

We are using several of their products...hope this helps.

deejaycez

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Active Directory and SQL Replication