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')
82 Responses
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!
Great, thanks for sharing this blog.Much thanks again. Want more.
I am sure this post has touched all the internet people,its really really nice piece of writing on building upnew blog.
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?
Thanks-a-mundo for the article. Will read on…
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
FACE TO FACE ,ZOOM OR TELEPHONE APPOINTMENTS YOU CHOOSE YOUR PREFERENCE
Major thanks for the blog article.Thanks Again. Fantastic.
Appreciate you sharing, great article.Really thank you! Much obliged.
I really enjoy the article.Really thank you! Cool.
Greetings! Very useful advice within this article!It is the little changes that will make the greatest changes.Many thanks for sharing!
Thanks again for the article post.Thanks Again. Keep writing.
Hello my friend! I want to say that this post is awesome, nice written and include almost all significant infos. I’d like to see more posts like this.
พนันบอลยังไงให้ได้เงิน แทงบอลชนะอย่างไรผิดโกง บาคาร่า จ่ายจริงจ่ายไม่ยั้งระบบเข้าใจง่าย แค่เพียงคลิกสมัครก็ทำเงินได้ง่ายๆกับคาสิโนออนไลน์ สบายสุดๆชีวิตชิวๆชีวิตคลูๆทำเงิน สร้างผลกำไรสบายๆต้องที่ บาคาร่า
Greetings! Very useful advice within this post! It’s the little changes which will make the biggest changes. Thanks for sharing!
Great blog post.
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Ö
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.
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!
Can someone recommend Bed Restraints and Under The Bed Ties? Cheers xx
powerful machine with much versions, we will talk about australia clenbuterol
free online slots online slots slots online
Thanks in favor of sharing such a good thought, paragraph is nice, thats why i have read it entirely
Bursa’da mobilya montaj hizmeti veren firmamıza hemen ulaşın ve hizmeti alın.
There is obviously a bundle to know about this. I feel you made some good points in features also.
trustworthy canadian pharmacy mail order pharmacy – safe online pharmacies
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!
doctors for hydroxychloroquine chloroquine and hydroxychloroquine
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!!
Hey!. Interesting material! I’m really appreciate it. It will be great if you’ll read my first article!)Loading…
Thanks a lot for the article post.Really looking forward to read more. Awesome.
Its fantastic as your other content : D, thanks for posting . “To be at peace with ourselves we need to know ourselves.” by Caitlin Matthews.
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.
Cómo reafirmar la piel del hundimiento: 6 consejos
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.
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!
At this time it sounds like Expression Engine is the best blogging platform out there right now.(from what I’ve read) Is that what you are using on your blog?
Thanks for one’s marvelous posting! I seriously enjoyed reading
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!
Looking forward to reading more. Great article.Thanks Again. Much obliged.
You can reach current women’s news with Grey Ombre Hair.
best canadian online pharmacies aarp approved canadian online pharmacies canada meds
Really plenty of awesome material!essays help top essay writing service writing services reviews
ivermectin 8000 mcg – ivermectin 1 ivermectin tablets
A big thank you for your blog article. Really Cool.
This article was really awesome Thank you for making it.
comparison to its earlier when it comes to gaming, and it has
Awesome post.Much thanks again. Will read on…
Enjoyed every bit of your blog post.Thanks Again.
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.
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.
I appreciate you sharing this blog article. Cool.
Enjoyed every bit of your blog post. Much obliged.
Thanks for finally writing about > رسالة تهديد للقادةالصوماليين بسبب التلكؤ في تسريعالعملية الإنتخابية – ستراتيجيا نيوز
Nice answers in return of this query with solid arguments and describing the whole thing on the topic of that.
I value the article post.Much thanks again. Great.
Water-proof and mechanical have become the strongest primary advantages of Rolex.
I wanted to thank you for this good read!! I absolutely enjoyed every little bit of it. I have got you book marked to look at new things you postÖ
I cannot thank you enough for the article post.Thanks Again. Great.
I really enjoy the blog article.Much thanks again. Fantastic.
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
I enjoy reading a post that can make men and women think. Also, thanks for allowing for me to comment.
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!
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.
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.
Greetings! Very useful advice within this article! It’s the little changes which will make the greatest changes. Many thanks for sharing!
Thank you for your blog.Really looking forward to read more. Great.
Oinxyo — effective cover letter Bzxyes ufcqxz
PROTEGE TUS DOLARES –> Abre una cuenta en Suiza„>desde Latinoamérica, con tu telefono móvil”>”>'”>
How much can you earn from this as a free member, spending a couple of hours a day?
It’s hard to find educated people for this topic, however, you sound like you know what you’re talking about! Thanks
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.
Hi there colleagues, its great piece of writing concerning tutoringand fully defined, keep it up allthe time.
Aw, this was an exceptionally nice post. Finding the time and actual effort to make a great article… but what can I say… I procrastinate a whole lot and don’t manage to get nearly anything done.
What’s up i am kavin, its my first time to commenting anywhere, when i read thisparagraph i thought i could also create comment due to this sensible piece of writing.
online pharmacy – canadian pharmacy ratings canadian pharmacy ratings
Major thankies for the blog post. Fantastic.
Very nice and informative.It is just i was looking for.
Definitely, what a splendid blog and illuminating posts, I will bookmark your blog.All the Best!
Really appreciate you sharing this blog article.Really looking forward to read more. Really Cool.
พนันบอลอย่างไรให้ได้เงิน แทงบอลชนะอย่างไรไม่ถูกคดโกง UFABET จ่ายจริงจ่ายไม่ยั้งระบบเข้าใจง่าย แค่เพียงคลิกสมัครก็ทำเงินได้อย่างง่ายดายกับคาสิโนออนไลน์ สบายสุดๆชีวิตชิวๆชีวิตคลูๆทำเงิน สร้างผลกำไรสบายๆต้องที่ UFABET
Hello! I just would like to offer a big thumbs up for the fantastic details you have here on this article. I will certainly be coming back to your blog for more quickly.