asked
Which factors depend upon Backup timing ?
Which factors depend upon Backup timing ? ex-source server/Destination server and bandwidth speed ? Is there any solution to calculate backup timing ?
Remember, if any answers are helpful, indicate those by clicking on the thumbs up next to the those answers. If any answer solves your problem, indicate that by clicking on the check box next to that answer.
As far as i'm aware you can only get this if you are running a [backup][1]. Try the script below from @SQLChicken and only works on 2005 and above. SELECT session_id, start_time, status, command, percent_complete, estimated_completion_time, estimated_completion_time /60/1000 as estimate_completion_minutes, --(select convert(varchar(5),getdate(),8)), DATEADD(n,(estimated_completion_time /60/1000),GETDATE()) as estimated_completion_time FROM sys.dm_exec_requests where command = 'BACKUP DATABASE' OR command = 'RESTORE DATABASE' [1]:
http://www.sqlservercentral.com/blogs/sqlchicken/2011/12/30/estimated-completion-time-for-backups-and-restores/
The primary limiting factor is the speed of your disks because you have to read and write each page of the database during the backup operation. If you know how fast your disks can do this, you can make a rough calculation as to how long it will take based on the number of pages in your entire database, but there's no way to account for resource contention, etc., ahead of time.
14 People are following this question.
