Rank: Administration Groups: Member
Joined: 3/24/2008 Posts: 2,732 Points: 5,372 Location: South Florida USA
|
SQL backup time estimate https://social.msdn.microsoft.com/Forums/silverlight/en-US/18237489-dfa7-42ea-90bb-fc3fe16727c0/how-much-time-my-1-tb-database-full-backup-takes?forum=sqldatabaseengineQuote: select command,percent_complete,'elapsed'=total_elapsed_time/60000.0,'to complete' = estimated_completion_time /60000.0 from sys.dm_exec_requests where command like '%Backup%'
|