Can you check what commands it was last running? DBCC INPUTBUFFER? It's possible that it's stuck and needs to be killed.

As John mentioned, more information and preferably code, would help.

I would learn towards a CTE if you have temp tables you are trying to use.

Craig is correct in that this is a network connection/visibility error.

However I'm not clear. You say two servers, and also mention a cluster. Are these both in a cluster? Are...

I saw a script from Kim Tripp recently that would restore to a point in time, and then check for changes, restore to a newer point, repeat.

The script is in...

Are the files in the main folder or sub folders? Make sure the Agent does not have a proxy as well.

I tend not to run this from a remote server,...

Bob Lee (11/11/2010)

---

I'm impressed. You should tell the folks at RedGate actually seeing this is what has me interested too. I sent in the information to have someone...

GilaMonster (11/11/2010)

---

Plus it should be 'the valley of the shadow of joins'

Yea though I walk through the valley of the shadow of joins, I shall fear no scans, for thou...

OCTom (11/11/2010)

---

What's the horse's name? I see you're riding bareback. A saddle would allow you to mount a bracket to it and have the iPad in front of you the...

I haven't. Just pinged him to see if he's OK.

I don't think that's true. The pages are smaller on disk, but in memory they are still 8kb pages. So it's not fewer pages, it's fewer IO operations that you...

So we can help you understand this, but you're asking a very general question, without any work on your part. The answer could be taken in a few contexts, so...

Ha, that's not a test. Unless you mean there...

That was good. Thanks.

http://msdn.microsoft.com/en-us/library/ms187030.aspx

Advanced option.

http://msdn.microsoft.com/en-us/library/ms187882.aspx

Since I work for Red Gate, here's SQL Doc:

http://www.red-gate.com/products/SQL_Doc/index.htm

I think most of them have evals. I'd give them a try and pick the one that works best for you out...