Database Restoring Status

hi, Zahidhussain your Question, not clear enough could you please explain more to able to help you.

As I understood from above:- 

That you need to check the restoring progress for your database so I suggest using below Query that will help you to know 

Note:-

the user who runs below should have sysadmin privilege or VIEW SERVER STATE permission

Use master

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 ('RESTORE DATABASE')

Thanks,