Looking at this as well. Looks like a transaction log backup OUTSIDE of DPM causes a transaction log chain invalidation error in DPM:

Log Name: DPM...

How's your OS memory usage on the two servers? Spawning 130 cmdshell processes on both ends seems excessive.

BlaineM:

Thanks! Got a plan for v1.1 now.

Craig-315134:

I agree with #1 in general. But sometimes you gotta do what you gotta do.

I couldn't disagree more with #2. If .NET isn't accessible to SQL Server DBAs, it...

Phil:

Ouch, OK, got me on that one, Phil (I can call you Phil, right?) I agree my solution is overall *more* lines of code, but it's OOP, something that one...

Since this is a SQL Server fourm, I assume you're implying "via SQL Server". In that case, you could possibly create one or more CLR procedures to do what you...

Whoever assigned a single spindle to the LUN didn't know what they were doing and so should no longer have that responsibility, or be properly trained on it. That's a...

That method does not work on 64-bit SQLm the CLR method does

Obviously, if the vendor can improve their stuff themselves, then that's the way to go.

Just as a side note FYI, there is legal precedence existing that excludes customer-added indexes...

Also, you mention you use 3 mirrored SCSI SATA drives. SCSI and SATA aren't the same thing. SATA is notoriously slow on write operations -- you will get much better...

Assuming the 3rd party code is not encrypted and that you have access to the cursor definitions, I suggest you ensure that each cursor definition has supporting indexes by generating...