When I was monitoring the backup process in MS-SQL 2008 R2, I saw the single database, say A, is handled by both SQL backup Job and TDP in the same time. When I tried to query Sys.sysprocess, I found the HEAD-block from TDP was blocking the process from SQL backup Job.
For example, SPID 100 (TDP) is backing up database A. Then, SPID 65 (SQL backup Job) is backing up database A.
select * from sys.sysprocess
where spid > 50 and status <> 'sleeping'The results expressed that SPID 100 is HEAD blocker that blocked SPID65.
The question is: Is this situation possible to be an Update Lock? and why?