While a backup/restore request is running, simply open a new query window and run the script.
/*
Queries the dm_exec requests and gives you an estimate of how long a backup/restore request is going to take
No Configuration needed
Author: mig.qui@gmail.com (however, I think I just found it on the internet)
Compatibility list:
MSSQL2005
MSSQL2008
MSSQL2008R2
MSSQL2012
DOES NOT WORK
MSSQL2000
*/
SELECT
session_id as SPID
, r.command
, a.text AS Query
, start_time
, percent_complete
, dateadd(second,estimated_completion_time/1000
, getdate()) as estimated_completion_time
, r.blocking_session_id
, r.wait_type
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a
WHERE 1=1
and r.command in ('BACKUP DATABASE','BACKUP LOG','RESTORE DATABASE') 
Backups. Are you confident you can restore? Do you have a process that ensures you can recover your systems? Learn how one system works in the cloud.
2018-04-19
1,386 reads
This script will perfrom following tasks :
1. BackUp DB
2. Restore DB from BackUp File
3. Restore DB from DB
4. Create a new DB from Existing Db
It takes care of all the possible failures during these operations, while done manually.
2017-01-11 (first published: 2017-01-09)
1,689 reads
This script simply returns the most recent restore information about databases for a server.
Returns the destination database name, the device used to perform the restore and the restore date.
2015-07-15 (first published: 2015-06-10)
717 reads
Perform automated database restores and check the integrity of your backup files
2014-08-11
5,399 reads
This article describes a way to automatically restore multiple database backups from a directory.
2014-04-21
6,114 reads