DECLARE
    killer
CURSOR
    LOCAL
    FORWARD_ONLY
    STATIC
    READ_ONLY
FOR
SELECT
    S.[session_id],
    S.[host_name],
    S.login_name,
    S.[program_name],
    S.last_request_end_time,
    duration_seconds =
        DATEDIFF(SECOND, S.last_request_end_time, GETDATE()),
    last_executed_query =
        LEFT(IB.event_info, 4000),
    kill_cmd =
        N'KILL ' + CONVERT(nvarchar(5), S.[session_id]) + N';'
FROM sys.dm_exec_sessions AS S
JOIN sys.dm_tran_session_transactions AS ST
    ON ST.[session_id] = S.[session_id]

DECLARE @cur CURSOR;
DECLARE @rows int;
DECLARE @db_name sysname;

SET @cur = CURSOR LOCAL FORWARD_ONLY STATIC READ_ONLY
FOR
SELECT [d].[name]
FROM [sys].[databases] [d]
ORDER BY [d].[name];

OPEN @cur;
SET @rows = @@CURSOR_ROWS;
WHILE @rows > 0
BEGIN
    FETCH NEXT FROM @cur INTO @db_name;
    PRINT @db_name;
    SET @rows -= 1;
END;
CLOSE @cur;

/* this is the database name where the BACKUP operation took place, not the database being backed up. */
    [CE79811F-1A80-40E1-8F5D-7445A3F375E7].[sqlserver].[database_name] = N'maintenance'
/* this is the name of the database that was backed up */
AND [database_name] = N'<database_of_interest>'

CREATE EVENT SESSION [backup_finished]
ON SERVER
ADD EVENT sqlserver.backup_restore_progress_trace
(
    ACTION
    (
        sqlserver.client_app_name,
        sqlserver.client_hostname,
        sqlserver.[database_name],
        sqlserver.nt_username,
        sqlserver.server_principal_name,
        sqlserver.[session_id],
        sqlserver.sql_text
    )
    WHERE
    (
        (
            (
                (
                    (
                        [backup_restore_progress_trace].[database_name]=N'database of interest'