Backup | Restore estimated time

Categories:

SQL Server

Display estimated time for backup and restore operations.

--- Backup Estimated Time
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SELECT @@servername as 'Server Name',
command as 'Command',
s.text as 'Statement',
start_time as 'Start Time',
percent_complete as 'Percent Completed',
CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ' hour, '
+ CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + 'min, '
+ CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ' sec' as 'Running Time',
CAST((estimated_completion_time/3600000) as varchar) + ' hour, '
+ CAST((estimated_completion_time %3600000)/60000 as varchar) + 'min, '
+ CAST((estimated_completion_time %60000)/1000 as varchar) + ' sec' as 'Estimated Time',
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) s
WHERE r.command in ('RESTORE DATABASE', 'BACKUP DATABASE', 'RESTORE LOG', 'BACKUP LOG')

Tags:

No Tag

82 Responses

  1. Thanks for the marvelous posting! I seriously enjoyed readingit, you’re a great author. I will make certain to bookmark your blog and will often come back from now on.I want to encourage you continue your great work, have a nice holidayweekend!

  4. Does anyone know whether I am able to purchase JUSTKRATOM Green Maeng DA Kratom Powder (justkratomstore.com) from EC Vape, 6601 Watauga Rd Suite 116, Watauga, TX, 76148?

  6. Buenos dias quisiera obtener mas informacion sobre las practicas en essalud y cuales son los sueldos por carrera, es de mi interes realizar practicas profesionales en este centro laboral. Odille Nowell Hinckley

  14. พนันบอลยังไงให้ได้เงิน แทงบอลชนะอย่างไรผิดโกง บาคาร่า จ่ายจริงจ่ายไม่ยั้งระบบเข้าใจง่าย แค่เพียงคลิกสมัครก็ทำเงินได้ง่ายๆกับคาสิโนออนไลน์ สบายสุดๆชีวิตชิวๆชีวิตคลูๆทำเงิน สร้างผลกำไรสบายๆต้องที่ บาคาร่า

  17. I need to to thank you for this fantastic read!! I definitely enjoyed every little bit of it. I have got you saved as a favorite to look at new things you postÖ

  18. Aw, this was an extremely nice post. Spending some time and actual effort to generate a top notch article… but what can I say… I hesitate a whole lot and never manage to get nearly anything done.

  19. Hello there, just became aware of your blog through Google, and found that it’s really informative. I am going to watch out for brussels. I’ll be grateful if you continue this in future. Many people will be benefited from your writing. Cheers!

  27. Hello there, just became alert to your blog through Google, and found that it is really informative. I am gonna watch out for brussels. I’ll be grateful if you continue this in future. Many people will be benefited from your writing. Cheers!

  29. Oh my goodness! Amazing article dude! Thanks, However I am having problems with your RSS. I don’t know why I cannot subscribe to it. Is there anybody else getting identical RSS problems? Anybody who knows the answer can you kindly respond? Thanx!!

  30. Hey!. Interesting material! I’m really appreciate it. It will be great if you’ll read my first article!)Loading…

  33. Heya i am for the first time here. I found thisboard and I to find It truly useful & it helped me out a lot.I hope to give one thing again and aid others like you helpedme.

  35. Aw, this was an exceptionally good post. Finding the timeand actual effort to make a great article… butwhat can I say… I hesitate a whole lot and don’t seem to getnearly anything done.

  36. This unique blog is definitely educating as well as diverting. I have picked a bunch of handy stuff out of this amazing blog. I ad love to return again and again. Cheers!

  39. I’m truly enjoying the design and layout of your blog.It’s a very easy on the eyes which makes it much more pleasantfor me to come here and visit more often. Did you hireout a developer to create your theme? Fantastic work!

  50. Aw, this was an extremely nice post. Taking the time and actual effort to generate a superb article… but what can I say… I put things off a lot and never manage to get anything done.

  51. Everyone loves what you guys are up too. Such clever work and coverage! Keep up the excellent works guys I’ve incorporated you guys to our blogroll.

  54. Thanks for finally writing about > رسالة تهديد للقادةالصوماليين بسبب التلكؤ في تسريعالعملية الإنتخابية – ستراتيجيا نيوز

  55. Nice answers in return of this query with solid arguments and describing the whole thing on the topic of that.

  61. I must admit that your post is really interesting. I have spent a lot of my spare time reading your content. Thank you a lot!Janeth Zeman

  63. Very nice post. I just stumbled upon your blog and wanted to say that I have truly enjoyed surfing around your blog posts. In any case I will be subscribing to your feed and I hope you write again very soon!

  64. Aw, this was an exceptionally good post. Spending some time and actual effort to generate a top notch articleÖ but what can I sayÖ I procrastinate a whole lot and never manage to get anything done.

  65. hi!,I really like your writing so so much! share we keep in touch more approximately your article on AOL?I require an expert on this house to unravel my problem.May be that is you! Looking forward to look you.

  66. Greetings! Very useful advice within this article! It’s the little changes which will make the greatest changes. Many thanks for sharing!

  72. I am not sure where you are getting your info, but great topic. I needs to spend some time learning much more or understanding more. Thanks for wonderful information I was looking for this information for my mission.

  81. พนันบอลอย่างไรให้ได้เงิน แทงบอลชนะอย่างไรไม่ถูกคดโกง UFABET จ่ายจริงจ่ายไม่ยั้งระบบเข้าใจง่าย แค่เพียงคลิกสมัครก็ทำเงินได้อย่างง่ายดายกับคาสิโนออนไลน์ สบายสุดๆชีวิตชิวๆชีวิตคลูๆทำเงิน สร้างผลกำไรสบายๆต้องที่ UFABET

Leave a Reply

Your email address will not be published. Required fields are marked *