Post reply

Database restoring,,,,, since 20 hrs

  • January 10, 2014 at 8:55 am

    #1679217

    Markus (1/10/2014)

    Do a SP_WHO2 and see what SPID your restore is running then do a SP_WHO2 99 with 99 being the thread number... and keep hitting enter to see if any of the numbers are increasing....

    or run this

    Select r.command

    , s.text

    , r.start_time

    , r.percent_complete

    , cast(((datediff(second, r.start_time, getdate())) / 3600) As varchar) + ' hour(s), '

    + cast((datediff(second, r.start_time, getdate()) % 3600) / 60 As varchar) + 'min, '

    + cast((datediff(second, r.start_time, getdate()) % 60) As varchar) + ' sec' As running_time

    , cast((r.estimated_completion_time / 3600000) As varchar) + ' hour(s), '

    + cast((r.estimated_completion_time % 3600000) / 60000 As varchar) + 'min, '

    + cast((r.estimated_completion_time % 60000) / 1000 As varchar) + ' sec' As est_time_to_go

    , dateadd(second, r.estimated_completion_time / 1000, getdate()) As est_completion_time

    From sys.dm_exec_requests r

    Cross Apply sys.dm_exec_sql_text(r.sql_handle) s

    Where r.command Like 'DBCC%'

    Or r.command In ('RESTORE DATABASE', 'BACKUP DATABASE', 'RESTORE LOG', 'BACKUP LOG');

    disrgard this... I reread your post and the restore is done but the db still shows as restoring. This won't help... sorry.

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply