I don't use proxies, so I'm just guessing that your problem is the underlined one...

This is what I found in BOL.

Books Online

---

SQL Server Agent proxies use credentials to store information...

I...

SP4? Whoohoo!

And here I thought they weren't planning any more SPs for 2k5.

That's Microsoft standard warning on all hot fixes and CPs. They don't want to take responsibility for Bad Things happening to your server if you put something on it that...

RE: Lock Pages in Memory. We have it set on our prod server and it hasn't caused any problems. I've never heard of the situation you've referenced, though.

Just keep watching it. Also, write down what times of day you're seeing this stuff happen. Maybe it's happening at the same time every day and that'll help you narrow...

Glad we could help. Let us know if you need anything else.

You have to make sure both are running at the same time. When both are done, open up Profiler and import the server side trace. Then go to File ->...

You really should run PerfMon and a server side trace to determine at what point the cache is eating the memory and to see if it's even related to SQL...

All,

This is a duplicate thread. Responses can be found at Fatal Error.

Yeah, well, I tried to be nicer about that point in my first point on this thread.

Well the OP isn't clear if the second server is on the cluster or not. I'm just assuming that's what (s)he meant.

But it wouldn't be the first time this week...

You can log ship to a server that has no instance?

I thought log shipped databases were in a state of Recovery? I thought they needed an instance to reside on....

Active / Active has a SQL instance on both nodes. Active / Passive has the instance only on one node. If you have instances on both nodes, you're running A/A...

It amazes me that someone would expect you to restore backups with no alternative cataloging system to identify this information. Automated backups through the maintenance plan or a third party...