Thanks Gents,

What I omitted to say was that SQL Server is stopped whilst we backup the data and log folders (.mdf and .ldf files). Therefore from your response SQLBill, I assume I am O.K....

yes i'm using enterpeise edition sp3a on Windows 2003 but moving to sp4 shortly

Thank you all for your responses so far. They have given me something to think about. I should have added that I would prefer to have one scheduled job that...

I forgot to mention I am making the OSQL call from a .bat or .cmd file. How do I capture the output and feed it in to another OSQL call...

Hello Paul,

I am using updatable subscription with immediate updating. So are you suggesting that there can never be any outstanding transactions awaiting replication from the subscriber to the publisher?

If that...

i am replicating 4 tables only, one of which has two triggers as dependencies. Both triggers have 'not for replication' on them on both the publisher and subscriber.

I would just like to add that I want to automate this procedure, therefore I don't want to use the GUI.

thanks T

Remi,

thank you very much, that has worked a treat.

T.

After further investigation I have discovered that this was an issue before the new build. Thanks for your response and I'm sorry if I have inconvenienced anyone.

t

Does this mean that I can't find out who is using the sa login thru any Microsoft product? Profiler can tell me what pc is using it, isn't there anything available...