Post reply

How to Keep SQL online with Connection loosing Packets

  • March 26, 2004 at 5:51 am

    #86313

    Is there a way in SQL 2000 to configure a kind of error check in transmission.

    I have w sites connected via RF at 2 Mbits. They are 11 Miles apparts and this is the only mean I have right here. The problem is that this antenas are very high and they swing a lot. With this movement I keep loosing transmission packets. This Happens like I loose one packet every 30. Can SQL2000 handle this kind of lose without disconnecting or loosing the info? If Yes, Do I have to configure this and where?

  • March 26, 2004 at 9:54 am

    #500691

    The transmission is completely dependent on the TCP/IP and OS. Windows can handle this fairly well, but SQL is less tolerant, especially for some things like backups. Your connections may or may not work. You can up things like timeouts and do retrys, but not sure that will help you.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply