Posted by debian mojo on 06/24/05 14:26

Hello Group,
I'm working on two SQL server databases on two different remote
servers. What client needs is that his database on one remote server
should be mirrored to the other one. The changed should be propogated at
regular intervals at the other server.

For now i'm quite sure that i'll have to use replication to resolve
this issue.

But which type of replication should i use? Transactional, Merge or
Snapshot?

Please note that the client is running his website from the main
server, which is using the source SQL Server database - the one i'll
have to replicate.

Last time when i tried to register the destination server, at my
source server Enterprise Manager, it gave me an error failing to
register the destination server. When i asked the client, all he could
tell me was that both the servers are firewalled and that might have
been the problem.

So just tell me how should i go for it?

Thanks in advance
Debian



*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: Replication Problem!
• Prev in forum: Re: sql server causes No buffer space available (maximum connections reached?): recv failed
• Thread view: Replication Problem!

[Reply to this message]