I have transactional replication between head office and branches located in different cities. network connection can go down sometimes and hence subscription can fail occasionally. now i am concerned about its effects. can anybody throw some light on this issue with possible precautions/setup and solution. one particular thing is subscription expiration: i read about it in books online, but i want to know from experienced guys about their practical experiences in this type of situation. what should be our option for transtional replication: never expires+reinitialization or expires after specified interval. In my replication, branch db is publisher and headoffice db is subscriber. At subscriber the data is changed after it is received from publisher, so i cant reintialize it now.