This was a bug in Management Studio 17.9.1.  sp_add_jobschedule was providing an incorrect value for @freq_type, which was 128 "Run when the computer is idle".  I found that if I...

My mistake.  We have several Azure initiatives underway and I just mixed-up two of the projects.  The restore issue is for Azure SQL Database.  We have a different issue for...

Steve,

We are essentially performing a POC of MI to determine if it is a viable solution for a project underway to migrate our first of several production SQL Servers to...

Thanks Grant.  That's what Microsoft just confirmed for me as well.  Oh well

In the end it doesn't matter, as long as we can perform point-in-time restores and as long as the IO isn't paused during a backup, which happens with DPM when...

Thanks for the reply.  We suspected the striping was causing more changes at the block level, and Commvault, like similar products, performs block-level data dedup.  Going from one backup file...

I completely missed the REBUILD. Now it makes sense. It didn't show up in previous deadlocks, but I enabled a couple TRACE flags today for more details so apparently...

Here is the deadlock graph from our most recent deadlock. The log information from my earlier post is for the same type of deadlock, but at a different time...

<TextData>

<deadlock-list>

<deadlock victim="process3482188">

<process-list>

<process id="process3482188" taskpriority="0" logused="0" waitresource="OBJECT: 10:1163151189:0 " waittime="3710" ownerId="5047445652" transactionname="WstrObjnameI4I4" lasttranstarted="2016-04-21T10:08:19.440" XDES="0x1dd3c5f740" lockMode="Sch-S" schedulerid="7" kpid="6536" status="suspended" spid="174" sbid="0" ecid="0" priority="0" trancount="2"...

That's the part that confuses me. The deadlock graph shows MODE: U for the victim, but the Service Manager process is MODE: X. Not sure why my insert...

Gail, I think you misunderstood my statement, or most likely I did not communicate it clearly. 😀 Either way I’m not proposing folder limitations, rather tighter drive permissions. True SQL...

Thanks. That makes sense to me as far as how he/she has the ability to place a backup on any drive, but I'm not sure I understand why this...

Thanks all. We're setting up a call with Microsoft to get a better understanding of how DPM works with SQL. We'll inquire about the impact of I/O being...

*** UPDATE ***

In June Microsoft filed the above problem as a bug with MEMORY MANAGER, as they were able to reproduce the issue in their lab. Their development team...

Thanks. That's a good idea. I believe there may be a few fairly large static tables in two of the larger databases on the server. I could...