sql server lock escalation deadlock

; with Tran_locks as (Select Resource_type,db_name (resource_database_id) as Db_name,resource_description, object_name (resource_associated_entity_id,resource_database_id) as Object_name,request_mode,request_type, request_status,request_session_idFrom sys.dm_tran_lockswhere resource_type= ' OBJECT 'UnionSelect Resource_type,db_name (resource_database_id) as Db_name,resource_description, object_name (p.object_id,l.resource_database_id) as Object_name,request_mode,request_type,request_status,reque

1) Manager does not actively refresh, need to manually refresh to see the latest status (performance considerations)2) In rare cases, the recovery process is suspended. This time assume that you want to recover and return to the accessible state, to execute:RESTORE Database dbnameWith recoveryThis allows the recovery process to end completely.3) If you want to continue to restore the log files later, you do need to put the database in the "Restoring State",This is usually done with the following