How to See When Your SQL Server Backup or Restore Will Finish

Summary withheld: an Opus review found that the machine-written summary did not match the post. Read the original post.

Quotes

“SQL Server already knows roughly when it expects to finish. You just have to ask for it.” (Explains that the solution builds on existing SQL Server functionality rather than requiring new tools)
“tells you the one thing people actually care about, which is when this will be done.” (Clarifies that estimated completion time directly answers the practical question DBAs need answered)

AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

other “sys.dm_exec_requests”
other “sys.dm_exec_sql_text”

Context

Features: backup monitoring, restore monitoring, estimated completion time, progress tracking, SQL Server system views

Source: Mohana’s Dynamics NAV & BC blog, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.