Incase anyone is watching this topic replication still appears to be running normally.

Barbara

J.Woo,

Right now it appears that may have resolved the issues.  I'm keeping my finger crossed. 

I'm curious as to why those indexes were not automatically created though.  I've had this...

J.Woo,

Thanks for your help, I'm setting up the indexes now. 

I'll update the post once I test it.

Thanks again,

Barbara

Thank you both very much for taking the time to respond to my post.

I have tested both of your suggestions a little, and definitely plan on testing it more as...

Thank Justin,

I'm not all that familiar with DTS.  I did look at that earlier when trying to resolve this issue but when I went on to the Transformations tab the script...

Martin - thank you very much for your input.

You've all given me a lot of great advice and I will definitely put it to use in coming up with a...

I thought that if I ran it twice a week it would help with performance, so I guess you could say I’m doing it for...

Thank you all for the additional information.  I know how sometimes things can come across not the way you intended in a posting so I want to say that...

Karl and Martin,

Thank you both very much for responding.

I tried setting up additional TL backup jobs but it appears that the Optimization job actually makes the TL Backup job take...

I have run into this issue in the past and what I did was I added a New Agent Profile and changed the QueryTimeout parameter from 300 to 600.  Then used this...

OK, I’ve done a little more probing into this and I think I’ve figured it out.