Home Forums SQL Server 2008 SQL Server 2008 - General Restore 1.9T on SQL 2008 RE: Restore 1.9T on SQL 2008
_Beetlejuice
Ten Centuries
Points: 1064
More actions
November 17, 2012 at 10:54 am
#1560017
This query will tell you how long the restore will take in seconds:
SELECT Percent_Complete, Estimated_Completion_Time / 1000 as [CompletionTimeSeconds]
FROM sys.dm_exec_requests
WHERE Command LIKE '%RESTORE%'