Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

database restore 2008 r2 Expand / Collapse
Author
Message
Posted Monday, January 28, 2013 5:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 2:05 PM
Points: 73, Visits: 475
Hi all,
approximately how much time the sql server 2008 r2 will take to restore 66GB of .BAK file.
Environment:
windows server 2008 R2
16GB RAM.
.bak file is in another machine.(not in server,from server i given path of that .bak file)

because for past 2 hours its showing 0%.


Thanks in advance
Post #1412369
Posted Monday, January 28, 2013 5:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:45 AM
Points: 5,221, Visits: 5,120
It depends....

Speed of network
IO performance
What else is happening on the servers




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1412379
Posted Monday, January 28, 2013 6:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
sathiyan00 (1/28/2013)
because for past 2 hours its showing 0%.


Creating and zeroing out the database files.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1412381
Posted Monday, January 28, 2013 6:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 15, 2014 2:05 PM
Points: 73, Visits: 475
no other tasks..only database restore is running on the server,also .bak file is in local network machine.
Post #1412382
Posted Thursday, January 31, 2013 1:48 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:32 AM
Points: 1,324, Visits: 2,941
Like a previous poster stated It depends... it really does... the age of your server, memory, high cpu when you are running the restore... high or low I/O operations....etc...

I can take a db backup of some size and restore it into different servers and the restore will take different lengths of time.


About the only way to know is to do it one time and you will know how long it will take.

Not the answer you want to hear but....



Post #1414323
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse