TIME TO RESTORE A 105G DATABASE

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

General SQL Server Forums

New to SQL Server Administration

TIME TO RESTORE A 105G DATABASE

Author

Topic

curzonhub
Starting Member

12 Posts

Posted - 2011-10-21 : 16:47:55

HI,
I have a question on time to restore a 100g database.We are moving the database in WAN to the other server,I created a shared folder on server A and restoring to server B.Its taking more then a day,is it normal??Am I doing some thing wrong?please help me!

am

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-21 : 18:08:44

Sounds like you've got an uncompressed backup, slow network, and perhaps slow disks on server B. You'll need to identify where your bottleneck is. Use PerfMon for help (both server A and server B).

You may find it faster to copy (zipped) the file to server B and then do the restore (unzipped of course).

What version of SQL Server is this for and what edition is it?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Kristen
Test

22859 Posts

Posted - 2011-10-22 : 06:47:42

If database is in full recovery you can:

Take full backup
Copy file to other server
Restore full backup WITH NORECOVERY (may take some time)

Stop access to original database
Take differential backup
Copy DIFF file to other server
Restore DIFF backup WITH RECOVERY (should not take very long)

which would reduce your "down time" (assuming that that is an issue for you ...)

curzonhub
Starting Member

12 Posts

Posted - 2011-10-22 : 16:18:02

@Tara,Thanks for the reply!As you said ,our network is very slow and the Disk as well.For now I stopped the restore ,and deleted the partially restored DB on server B.I am performing a full a full backup again on server A.If we compress and copy the file to server B ,and restore locally will it make some difference?Its a 2000 version, both the Servers are 2000.

Thanks in Advance!

am

curzonhub
Starting Member

12 Posts

Posted - 2011-10-22 : 16:21:17

@Kristen, Thanks for the reply.I have down time until Monday,I tried to copy the file to Server B but It is taking the same time to copy on the Network.I was actually planning to restore the recent full back up and do a Diffrential today,but It was too slow that I was not able to Restore Full back up...

am

curzonhub
Starting Member

12 Posts

Posted - 2011-10-22 : 17:24:04

@Cindyaz,I tried Compressing but It says too large for compression.I need to use some software may be,Thank you..

am

Kristen
Test

22859 Posts

Posted - 2011-10-22 : 17:44:11

www.winzip.com perhaps?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources