[thelist] MS SQL Server: database replication over ADSLconnection?
Jason Handby
jasonh at corestar.co.uk
Thu Sep 30 03:33:21 CDT 2004
Hi Scott,
> > Is this going to work over a network connection that's not
> incredibly
> > swift and might not be reliable? If the connection drops
> out what will
> > happen?
> > Will the remote SQL Server (and hence my website) grind to a halt?
> > Will I
> > lose data?
>
> I suggest reading up on SQL Server replication, and also what
> that will do to your MSDE -- MSDE is limited in number of
> connections, and Replication will eat up some (at least one)
> of those. Replication is basically a client connection to the
> destination server, copying instructions culled from the
> transaction log to the destination. It is a transaction-based
> operation, and will pretty much behave okay if the connection
> goes up and down. One thing to be aware of is by default (SQL
> Server 2000) subscriptions expire very quickly if the
> connection breaks, requiring some hurdles and hoops to jump
> through to get it back up. But anyhoo, SQL Server Replication:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-
> us/replsql/replover_694n.asp
Thanks for your message. Just to clarify: I am already reading about SQL
Server replication, but would be keen to hear from anyone who has any actual
experience of doing this in a similar setup to mine (i.e. over ADSL).
Jason
More information about the thelist
mailing list