Скачать или смотреть How long-time will take to complete the database Backup or Restore | Estimated time of Restoration

Estimated Completion Time for Backups and Restores
How can I check the status of a backup operation?
script to get an estimate of backup times
Estimated Completion Time for Backups and Restores
How to check backup time in SQL Server?
How to estimate time to complete rman backup?
How to estimate query completion time in SQL Server?
How do I create a SQL backup schedule?
time in SQL Server
Script to check backup status in SQL Server
How to check database restore progress in SQL Server
Backup estimation in SQL Server
Query to check backup percentage in SQL Server
How to check SQL backup schedule
Query to check backup status in oracle
Estimate query completion time SQL Server
Determine or Estimated time (ETA) of Backup & Restoration
How long-time SQL Server will take to complete the database Backup or Restore?
How long-time will take to complete the database Backup or Restore?
SQL Server
T SQL
DBA
ETL
Azure SQL
Database developer
Script -
SELECT session_id AS [Session_Id] ,
command AS [command] ,
CONVERT(NUMERIC(6, 2), percent_complete) AS [percent_complete] ,
CONVERT(VARCHAR(20), DATEADD(ms, estimated_completion_time, GetDate()), 20) AS [Estimated Completion Time] ,
CONVERT(NUMERIC(32, 2), estimated_completion_time / 1000.0 / 60.0) AS [Estimated Min] ,
CONVERT(NUMERIC(32, 2), estimated_completion_time / 1000.0 / 60.0 / 60.0) AS [Estimated Hours]
  
FROM sys.dm_exec_requests WHERE command like 'RESTORE%'or command like 'BACKUP%'