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.
| Author |
Topic |
|
agiotti
Starting Member
37 Posts |
 Posted - 2010-08-24 : 15:59:10
|
| SQL Server 2005 Enterprise.Replicating to a remote site. If we drop our connection the replication stream is broken. Upon re-establishing the connection all articles are resent to the subscriber. Is there a way to recover the replication stream to only transfer transactions that are new or changed instead of everything? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-24 : 16:03:13
|
| it will pick up where it left off. transactions will be stored at the distributor until it can reconnect to the subscriber.unless your subscription is set to expire if connection is dropped. can view that in the publisher properties |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-08-24 : 16:24:53
|
| It also depends on how long the connection was broken. The default of the distributor is to delete the data after 72 hours, even if the transactions haven't been delivered to the subscriber. So if you are beyond the 72-hour window, then you'd have to start from a new snapshot. You can change the 72-hour retention via the distributor properties or the SQL distribution cleanup job. Please note that increasing the retention could cause performance issues, which could lead to replication latency.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
agiotti
Starting Member
37 Posts |
Posted - 2010-08-24 : 18:50:17
|
| thank you very much for all your replies!!!! This has been very helpful. |
|
|
|
agiotti
Starting Member
37 Posts |
Posted - 2010-08-24 : 19:34:25
|
| One more question. We built a test system mirroring production, replicating to a remote site. If we restore the publisher database and the subscriber database how can we begin replication without performing a full snapshot first? In otherwords, how do inform the engine both copies are identical and only want to replicate changes? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
agiotti
Starting Member
37 Posts |
Posted - 2010-08-24 : 19:46:34
|
| Tara you are awesome! thank you very much! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Recovery Replication Stream
Tara Kizer