January 28, 2008 at 2:26 pm
How long will it take to take full backup for 200 GB into Tape drive and Restore Vise-Versa In 2000?
January 28, 2008 at 7:01 pm
That completely depends on the drive and whether or not it is local to the server. Why not get a db thats about 3-5gb, do a test backup to tape and review the transfer speed in the backup software. Then you can work out how long it will take for 200gb roughly
January 28, 2008 at 8:06 pm
That worksfor extrapolating full backup times, but doesn't work for restore times. One of the phases of restore (well technically two of them) is to run recovery on the transaction log contained in the backup so the database is brought to a transactionally consistent point in time. Depending on what transactions are running at the point the database backup finishes reading the data, that could be a lot of transaction log.
See http://www.sqlskills.com/blogs/paul/2007/10/25/DebunkingACoupleOfMythsAroundFullDatabaseBackups.aspx for more details.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply