rather than risking your job,

why not find out the basis for removal of the dba's from the server.

Not everything is available to either QA or MMC, for example perfmon...

you can jump right to sp4, which brings you to version 2039.

I'd also recommend at least the 2040 hotfix if you are using AWE memory. Last I checked, the...

I put a note into the report problems section, reporting anything I was actively running, plus some details on a few of the background processes as well, to try to...

Sure, no problems.

I'll get him any details that are relevant. The troubling thing is that it does seem to be random. Sometimes it doesn't take any cpu at...

I agree.

When I first ran across the new ad, I thought it was a very interesting way to handle advertising.

This is the third day in a row, however,...

I've noticed similar issues while browsing with firefox. the next page resetting to the first page, etc. is that the browser you're using?

/3gb and > 4gb of ram don't mix well.

My recommendation would be to set boot INI to :

/PAE

SET max server memory to 6xxx (leave 2GB for os functionality) make sure...

couple of additional things,

if you have your original server available, comapre sp_configure statements and validate any differences that you find. Perhaps Max degree of parallelism was set to 1...

I should also point out that if this is a 1 off thing (you are not trying to script it for multiple instances) you can expand management, right click...

found this on Microsoft:

http://support.microsoft.com/?kbid=196909

which has the following key point, By default, this key is absent.

The new registry key that you can set is:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\NumErrorLogs

By default, this key is absent....

It has been a while since I've setup log shipping, but yes, you should be able to delay either the log shipping copy jobs, or the log shipping restore jobs,...

All the above points are great.

I just want to reiterate that having fully qualified code, it is imperative to have the databases named the same, so that you have the...

That's why it's important to make sure on restores you know what you're dealing with.

The restore HEADERONLY comment above is a great tool.

and syntax is what is mentioned above:

how are...

what is the syntax of the entire restore process you are using, for the full, the diff, and the logs?

have you run cliconfg and created named pipes aliases on BOTH nodes of your cluster? There's a KB article on this, but I can't remember it offhand.

w2k3 disables named...