"gosound" <u21279@uwe> wrote in message news:5f68bcace3661@uwe...
> Hello everyone,
>
> During our nightly replication we replicate a table SERV from a third
> party.
> This table contains codes for all open and closed orders from the past 2
> years. It is around 3 - 3.5 GB of total data. The console starts the
> first
> attempt around 2145 - 2130 and the table runs until around 0100 - 0200.
> Every night the first attempt throws an exception with "Timeout exceeded".
> This only occurs while we are transferring other large tables
> simultaneously.
> If SERV is running by itself no exception is thrown. The problem is the
> timeout is set to expire at 8 hours and the timeout exception is being
> thrown
> between 2 - 4 hours.
>
> Microsoft has a hotfix addressing the exact issue we were experiencing,
> but
> did not seem to work.
>
> KB Article Number(s): 912151, 912731, 912732, 913176, 913177, 913764,
> 913765,
> 913766, 913767, 913768, 913772
>
> Language: All (Global)
>
> Platform: i386
>
>
> Anyone have any ideas?

Hilary Cotter wrote:
>what is your commitbatchsize, if its the default I would drop it to 1000.
>
>Also are you using snapshot replication? Any way you could use
>transactional?
>
>> Hello everyone,
>>
>[quoted text clipped - 25 lines]
>>
>> Anyone have any ideas?