Some time in SQL backup or restore database process takes more than the usual time and we are not sure when it will going to be completed.
you can execute the below query and it will display the current status of it and also the estimated time of completion
SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time
FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a
WHERE r.command in ('BACKUP DATABASE','RESTORE DATABASE')
Result will be as per below.
