Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restoration Time of Backup

Author  Topic 

rardales
Starting Member

32 Posts

Posted - 2004-12-29 : 14:16:10
How long does it typically take to restore the database? I'm restoring our database of about 3.63 gb. It's been restoring for about 40 minutes. It's almost done; the progress bar is on it's last two bars and it's been like that for about 20 minutes.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-12-29 : 14:23:18
3.63GB should restore in under 15 minutes. You must have some slow disks on that server.

Tara
Go to Top of Page

rardales
Starting Member

32 Posts

Posted - 2004-12-29 : 14:35:13
That server is pretty full. I should clean it up.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-12-30 : 02:11:11
If transaction backups have NOT been made [and recovery mode set to FULL], then a restore can take a VERY long time (even though backup file is relatively small).

Kristen
Go to Top of Page
   

- Advertisement -