{"id":64,"date":"2020-02-02T18:14:17","date_gmt":"2020-02-02T18:14:17","guid":{"rendered":"http:\/\/ictbank.ir\/blog\/?p=64"},"modified":"2020-03-26T00:52:42","modified_gmt":"2020-03-26T00:52:42","slug":"backup-restore-progress","status":"publish","type":"post","link":"https:\/\/ictbank.ir\/blog\/backup-restore-progress\/","title":{"rendered":"Backup\/Restore Progress"},"content":{"rendered":"\n<p>To see the progress of Backup or Restore process you can use this query: <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT r.session_id AS &amp;#91;Session_Id]\n    ,r.command AS &amp;#91;command]\n    ,CONVERT(NUMERIC(6, 2), r.percent_complete) AS &amp;#91;% Complete]\n    ,GETDATE() AS &amp;#91;Current Time]\n    ,CONVERT(VARCHAR(20), DATEADD(ms, r.estimated_completion_time, GetDate()), 20) AS &amp;#91;Estimated Completion Time]\n    ,CONVERT(NUMERIC(32, 2), r.total_elapsed_time \/ 1000.0 \/ 60.0) AS &amp;#91;Elapsed Min]\n    ,CONVERT(NUMERIC(32, 2), r.estimated_completion_time \/ 1000.0 \/ 60.0) AS &amp;#91;Estimated Min]\n    ,CONVERT(NUMERIC(32, 2), r.estimated_completion_time \/ 1000.0 \/ 60.0 \/ 60.0) AS &amp;#91;Estimated Hours]\n    ,CONVERT(VARCHAR(1000), (\n            SELECT SUBSTRING(TEXT, r.statement_start_offset \/ 2, CASE\n                        WHEN r.statement_end_offset = - 1\n                            THEN 1000\n                        ELSE (r.statement_end_offset - r.statement_start_offset) \/ 2\n                        END) &#039;Statement text&#039;\n            FROM sys.dm_exec_sql_text(sql_handle)\n            ))\nFROM sys.dm_exec_requests r\nWHERE command like &#039;RESTORE%&#039;\nor  command like &#039;BACKUP%&#039;\n<\/pre><\/div> ","protected":false},"excerpt":{"rendered":"<p>To see the progress of Backup or Restore process you can use this query:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"templates\/template-full-width.php","format":"standard","meta":{"footnotes":""},"categories":[22,8,21],"tags":[26,6,24,28,27,23,25],"class_list":["post-64","post","type-post","status-publish","format-standard","hentry","category-backup-restore","category-database","category-mssql","tag-backup","tag-database","tag-mssql","tag-progress","tag-restore","tag-sql","tag-sqlserver"],"_links":{"self":[{"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/posts\/64","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/comments?post=64"}],"version-history":[{"count":2,"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions"}],"predecessor-version":[{"id":140,"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/posts\/64\/revisions\/140"}],"wp:attachment":[{"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/media?parent=64"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/categories?post=64"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ictbank.ir\/blog\/wp-json\/wp\/v2\/tags?post=64"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}