Monitoring database updation / LAN connection

[Ranjeet_Singh]

Local database which is in PC where application is running, and network database which is server in remote PC. if it handles all by itself then when LAN disconnected and later when connected again why data is not updated? just a question.

My only concern is during testing if LAN disconnected then data is not updated to main SQL and hence in later stage when same record is checked, it is not present although LAN is connected again. How to ensure that LAN is connected and record is being updated to DB without being read it back. In previous post someone suggested me for DB transaction. 

In short, if LAN is disconnected then my application should be able to find it and generate an error message.

[mikeporter]

The way replication typically works (though this is configurable) is that the databases can either check on a regular schedule for data that needs to be exchanged, or replicate the data to the target destination as soon as there is new data.
If an update fails for any reason, the databases will reattempt the data transfer the next time the replication is triggered (scheduled time or new data). In general it will not just sit there and keep trying over and over again -- which is a good thing as blind retries could eat up a bunch of processor time and network bandwidth.

Mike...

[Ranjeet_Singh]

I doubt if setting is done in my server. Can you please let me know from where I can do this setting.

[mikeporter]

As I said originally, Google is the place to find detailed information -- start with "sql server replication" as a search term. And don't forget to leverage your in-house IT resources.

Mike...