Subscription not valid -2147201019

[Laffern]

Anybody knows the error's background ? Made a replication between the SQL Server and PDA Devices. After few sucessfull attempts, the error occurs. The subscription becomes invalid. Is there a way to stop this ?

 

[Catadmin]

What kind of replication is it? Merge, Transactional, Snapshot?

I think Transactional Rep requires a permanent or near permanent connection.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!

 

[Laffern]

It's a merge replication. Yesterday I found an option to modify subscribtion length and switched it to unlimited (possible performance problems may occur). But that cannot be the best solution.