It sounds like you have reached a memory limit in your current configuration. We have experienced some of what you are referring to and have worked through most of it...

Sorry for taking so long to reply again on this but if they are the same SLA and the same version of SQL then I would only use one instance...

...and to further what Lynn was saying, wait till you do a verify of a backup that is on tape. Sleep, snore, sleep, snore, get coffee, etc.... 🙂

Honestly, I don't like having a tape backup agent backup the databases. Backup files, great. I have voiced this many times on this site but I tend to a bit...

Based on what you are saying it sounds like you should be using merge replication not transactional.

Reinstall the client tools on the server where things are behaving strange? 😀

Seems like some pretty strange happenings for sure. If you are using the same account from both locations...

The error that you posted is from MSSQLSERVER (note the EVENT SOURCE: label). So, there definitely appears like their might be an issue with the memory utilization for the instance....

Any time you hold multiple instances on one server you add some complications to your maintenance so, with that being said, your coworkers concerns are not unfounded. While I believe...

Can you look in the install log and get any error and post them here? Thanks in advance.

Yeah, sorry that I don't have any other suggestions. Hopefully someone else will.

Totally understand the whole SQL / VBScript aspect as well. I don't know if I could code...

Yes, you can use SSMS in 2005 to generate scripts for indexes. I always recommend having these things scripted out and testing those scripts prior to putting them into production....

Yes you can. Stop the agent affecting that replicated publication / article. Then you can use the following queries to find what replicated transactions you need to delete. Please note...

Any errors that you can provide to further troubleshoot?

Yeah, just be prepared for the userX calls saying that his / her ad-hoc queries are running really slow today and they can't figure out why. 😛 Of course, that...

Hey Adam,

Familiar with the structure that you have laid out but have never seen a tool like that. Maybe you should consider writing something? 😉 Might sell...

Alternatively, if you...