Replication

Last Post 02 Oct 2008 02:29 PM by sickle. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sickle
New Member
New Member

--
26 Sep 2008 05:24 PM
Hi,

I have one SQL Server 2005 Standard Edition that replicates data to many SQL Server Express Edition by VPN. All works fine, but when a subscriber lost its VPN connection for a while, SQL Server stops the replication for this subscriber. I wish I can setup SQL Server Standard Edition to retry the replication until the VPN connection is restablish. For now, I always have to manually restart the replication. It's very annoying for me and my clients. Is there an option I missed somewhere ?

Thank You,

Claude Petit
SQLUSA
New Member
New Member

--
28 Sep 2008 10:34 PM
Claude,

Is PULL subscription a possibility?

Link: http://msdn.microsoft.com/en-us/lib...L.90).aspx

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
sickle
New Member
New Member

--
02 Oct 2008 02:29 PM
I don't know. I'll give a try when I'll have time. But the replication works very well. The only problem, is it stops synchronisation for a subscriber that is unreachable for a while. Is there an option to increment this "timeout" ?
You are not authorized to post a reply.

Acceptable Use Policy