— View actively running commands by SPID.
select session_id, Text
from sys.dm_exec_requests r
cross apply sys.dm_exec_sql_text(sql_handle) t
Troubleshooting
Backup failed: System.Data.SqlClient.SqlError: Backup and file manipulation… must be serialized