MSSQL查询备份或还原等操作的大概完成时间脚本

最新推荐文章于 2022-02-18 14:19:27 发布

人生小果

最新推荐文章于 2022-02-18 14:19:27 发布

阅读量788

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL Server

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.youkuaiyun.com/Shiney927/article/details/48287827

SQL Server 专栏收录该内容

14 篇文章

订阅专栏

   select command
   ,percent_complete
   ,running_time=convert(varchar,((datediff(s,start_time,getdate()))/3600))+' hour, '
                +convert(varchar,((datediff(s,start_time,getdate()))%3600/60))+' min, '
                +convert(varchar,((datediff(s,start_time,getdate()))%60))+' sec'
   ,est_time_to_go=convert(varchar,(estimated_completion_time/1000)/3600)+' hour, '
                  +convert(varchar,(estimated_completion_time/1000)%3600/60)+' min, '
                  +convert(varchar,(estimated_completion_time/1000)%60)+' sec'
   ,start_time=convert(char(16),start_time,120)
   ,est_completion_time=convert(char(16),dateadd(second,estimated_completion_time/1000,getdate()),120)
   ,s.text
   from sys.dm_exec_requests r
   cross apply sys.dm_exec_sql_text(r.sql_handle) s
   where r.command in ('BACKUP DATABASE','RESTORE DATABASE','BACKUP LOG','RESTORE LOG','DbccFilesCompact','DbccSpaceReclaim')