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.
| Author |
Topic |
|
LearningSQLKid
Yak Posting Veteran
51 Posts |
 Posted - 2011-12-20 : 01:10:08
|
| Hye GuysI'm trying to restore a database from backup but its very slow. It is taking about 2 hours to restore 80 GB database.I tried to restore the same on VM and it took only 10 minutes to restore. However on my local system its taking too much timei'm using SQL SERVER 2008 R2, Windows 7 64 bit Any thoughts ?Select Knowledge from LearningProcess |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-20 : 04:57:47
|
Are you retoring the backup on the existing database or a new database?What does this return in case you are retoring on the existing database?select log_reuse_wait_desc from sys.databases where name='YourDBName' PBUH |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2011-12-20 : 05:09:53
|
| Where is your backup file located on the locally or over the network, this is the usual problem I have and its just down to network usage at the particular time. |
|
|
|
LearningSQLKid
Yak Posting Veteran
51 Posts |
Posted - 2011-12-20 : 19:06:28
|
quote:
Originally posted by NeilG
Where is your backup file located on the locally or over the network, this is the usual problem I have and its just down to network usage at the particular time.
Hi NeilGBackup file is located on my local drive not on the netwokSelect Knowledge from LearningProcess |
|
|
|
|
|
|
DB Restore is Slow