USE master
GO
SELECT
Percent_Complete,
Start_Time ,
Command,
b.Name AS DatabaseName, --Sometimes this will be "Main" as the database will not be accesiable.
DATEADD(ms,estimated_completion_time,GETDATE()) AS RemainTime,
(estimated_completion_time/1000/60) AS MinutesToFinish
FROM sys.dm_exec_requests a
INNER JOIN sys.databases b
ON a.database_id = b.database_id
WHERE
Command like '%Restore%'
OR Command like '%Backup%'
AND Estimated_Completion_Time > 0
Tuesday, November 18, 2008
Subscribe to:
Post Comments (Atom)
9 comments:
Hey This script is beautiful.. i tried alot to findout this script.. but finally i got here..
Great work sandesh.. really appreciate it..
Awsome. It works perfectl
Sen.
Perfect !!!
Query to Find time remaining to complete Rebuild Index for entire DB.
Hi, we can rewrite the command for Checking Backup and Restore estimated time.
select percent_complete ,estimated_completion_time/60000 RemMin,* from sys.dm_exec_requests where command ='backup database'
Nice Article !
Really this will help to people of SQL Server Community.
I have also prepared small note on this, find estimated finish time of the restore SQL Server database.
http://www.dbrnd.com/2015/11/sql-server-script-to-find-estimated-finish-time-of-the-restore-database-2/
Nice blog... This blog clearly shows the important of automatic backup of SQL server database. This help to secure data. Thanks for sharing
I was very happy to find this site. I really enjoyed reading this article today and think it might be one of the best articles I have read so far. I wanted to thank you for this excellent reading !! I really enjoy every part and have bookmarked you to see the new things you post. Well done for this excellent article. Please keep this work of the same quality.
Data Science Course in Bangalore
http://www.offshorededi.com offers high quality DMCA Ignored Hosting. We make offshore hosting simple for you to use with reliable servers and one-click installers.
Post a Comment