question

skbarik avatar image
skbarik 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 ?
backupscalculations
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
1 Like 1 ·
sp_lock avatar image
sp_lock answered
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/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.