SQL Server Power Search - Get More Relevant Results

How much time to take a backup for 300GB?

by THIRU
(BANGALORE)

How much time to take a backup for 300GB?

Comments for
How much time to take a backup for 300GB?

Click here to add your own comments

Jul 26, 2010
 It Depends
by: Richard

Well, Thiru, that's a very open ended question. The answer depends on so many different variables.

How fast is your disk subsystem?
Are you backing up locally, or over the network?
Is it a native, uncompressed backup, a compressed 2008 backup, or are you using a third party backup tool?
If compression is used, the degree of compression will depend on the data, and that will also affect backup times.

The only way to find out is to try it yourself.

Jul 30, 2010
 Go eSATA with PCI host adapter card
by: ElectricLynn

www.seagate.com
www.wdc.com

are the best places to explain speed. It all depends upon hardware and much of what they have to offer can even be external with a plug n play PCI card.

But Backup! Data is much too precious to lose. Have FUN!
Feb 14, 2011
 About How Much time to take backup.
by: Uday

In an SQL server 2000 it is not possible to say or tell how Much completed how ever in the all new versions we have an beautiful DMV's
that do's the trick i,e we can Identify how long it may take backuo or restore or how much percentage it is completed.

DMV which supports ->sys.dm_exec_requests


Use the below script to Identify
===============================

SELECT command,
session_id,
percent_complete,
DATEADD(ms, estimated_completion_time, GETDATE()) AS estimated_completion_time,
GETDATE(),
start_time
FROM master.sys.dm_exec_requests
WHERE percent_complete > 0

or

you can use Select * from sys.dm_exec_requests

How ever certain factor may lead to take more time in case
if heavy load on I/O level,firing queries by users when the backup is running(this case when dbsize is >500GB or >5TB -I have seen the case here).if the DISK heavly fragemented...etc..

Best Regards,
Uday

Click here to add your own comments

Join in and write your own page! It's easy to do. How?
Simply click here to return to SQL FAQ

Navigation

SQL FAQ

You are in the SQL FAQ.

This is where you can ask and answer questions about any aspect of SQL Server.

Help to build an authoritative source of information.

Click the link above to start contributing now.