Viewing 15 posts - 1,261 through 1,275 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 4, 2008 at 2:15 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 3:55 pm
...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.... 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 3:44 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 3:13 pm
Based on what you are saying it sounds like you should be using merge replication not transactional.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 10:42 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 5:36 am
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 5:31 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 5:21 am
Can you look in the install log and get any error and post them here? Thanks in advance.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 3, 2008 at 5:02 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 3:30 pm
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 3:26 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 3:18 pm
Any errors that you can provide to further troubleshoot?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 3:01 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 1:45 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 2, 2008 at 1:42 pm
Viewing 15 posts - 1,261 through 1,275 (of 1,790 total)