MS SQL Узнать процент создания/восстановления бекапа БД/лога транзакций

SELECT
    [command]
    ,[start_time]
    ,[percent_complete]
    ,[estimated_completion_time] / 60000. AS [estimated_completion_time_min]
FROM sys.dm_exec_requests
WHERE [command] = 'BACKUP DATABASE'
    OR [command] = 'RESTORE DATABASE'
    OR [command] = 'BACKUP LOG'
    OR [command] = 'RESTORE LOG'
    OR [command] LIKE '%DBCC%'
0

Добавить комментарий

Ваш e-mail не будет опубликован.