Viewing 11 posts - 1 through 11 (of 11 total)
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...
November 2, 2011 at 7:44 am
How's your OS memory usage on the two servers? Spawning 130 cmdshell processes on both ends seems excessive.
September 28, 2011 at 7:59 am
Thanks! Got a plan for v1.1 now.
July 18, 2011 at 2:54 pm
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...
July 18, 2011 at 2:52 pm
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...
July 18, 2011 at 2:43 pm
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...
July 18, 2011 at 6:47 am
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...
July 20, 2010 at 10:30 am
That method does not work on 64-bit SQLm the CLR method does
December 8, 2009 at 9:26 am
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...
August 8, 2008 at 1:59 pm
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...
August 8, 2008 at 7:01 am
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...
August 8, 2008 at 6:53 am