What is the issue of taking an ad hoc backup on the fly? Are you saying the problem is that the log backups then follow this backup? If so that...

I did a test of sending 500000 records up the line. With maxcmdsintran set to 100000 so 5 transactions it took 17:57. With 1 transaction of 500000 it took 17...

I would turn the subscriber identity field off. It should then just pass the ID down as it is.

This is if I have understood your issue. 😉

Thats network traffic for you. I think you need to check out your disk setup and run it from the same server. Again though I wonder why you don't allow...

Just for interest, why do the customers not just access the files straight from the source instead of pumping out to a named instance?

I can transfer a large file normally and it takes as long as it should over the same line. Although I guess the settings causing collisions would be more so...

Well this is ridiculous. I am testing over a 3mb line at present. I left the job running overnight. The querytimeout set at 7200 let it through - so took...

Another question to go with the above - What order does Transactional Replication run stuff? Because if it is timing out running sp_MSadd_distribution_history against the publication distribution db....

What does that...

Now trying to get my test distribution job to not timeout using a querytimeout of 3600 and commitbatch and threshold of 100 and 1000. Will post results.

At the moment it...

Distribution times out on

{call sp_MSadd_distribution_history(9, 3, ?, ?, 0, 0, 0.00, 0x00, 1, ?, 0, 0x00, 0x01)}

With querytimeout set to 3000! Madness.

More information...

This was the finishing time on the Log Reader for a test I did with one of the tables...(this was the insert stage so doesn't include the delete)

Transactions 869

Commands...

I am confused. You say you "removed" the records you had manually added in, and now you say you think replication "removed" the records.

My experience is of transactional replication, but...

Its one of our sql 2000 servers actually. Plopped the question in here out of habit!

Luke L (8/11/2009)

Cause you use the British...

I agree totally with all that, but why so that my servers can not interpret SELECT isdate('2009-06-30') as a valid date?

And surely these should both work if 1 works?

select...