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 2005 Forums
 SQL Server Administration (2005)
 restore

Author  Topic 

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2009-07-24 : 22:11:58
Hi,

I'm restoring database from .bak file. I just run restore monitoring query and noticed that 42 hours to restore. Is there any way I can create database faster on another server?

Please advice.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-07-24 : 22:13:10
How big is backup file?
Go to Top of Page

sqlserverdba
Yak Posting Veteran

53 Posts

Posted - 2009-07-24 : 22:28:40

150Gb around.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-07-25 : 20:36:51
Where is your another server? Same location or Different? and Network bandwidth?
Go to Top of Page
   

- Advertisement -