Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm just restoring a small database(-5MB) but it is taking a lot of time?
Is it standard or darkness is a feature?

share|improve this question
    
answer for other people:the best way to restore is deleting the database before restore.then it takes 5 secs. –  Behrooz Jun 3 '10 at 20:12
add comment

3 Answers

Depends on where it's restoring from. If you're taking it from tape, even the smallest file will need seek time, which depending on the tape drive could be a substantial multiple of the actual restore time needed. A restore job may also require to index and/or catalog the restore media.

share|improve this answer
    
solved just few seconds ago.and it was restoring from the c:\program files\....\MSSQL\....bak –  Behrooz Mar 22 '10 at 15:56
add comment

Takes way too long. Anything funny in the logs? 5 mb should take seconds - lets say a minute, maximum. That is MAXIMUM in HUGH letters. Unless you have a 300gb log file that needs processing after restoring the database.

share|improve this answer
    
it is still restoring.help!!!that is important data. –  Behrooz Mar 22 '10 at 15:09
    
the log is about 700MB.but the database was cleared before the time i am trying to restore. –  Behrooz Mar 22 '10 at 15:21
    
700mb log on a 5mb database- can take some time, especially if... well... the disc subsystem is "workstation quality". You ahve tons of disc activity? –  TomTom Mar 22 '10 at 15:31
add comment

Try adding "with stats = 1" to your restore clause so you can see some movement. My guess is the log file being created is the issue, you could switch the db recovery mode to simple mode and shrink the log down (don't tell Paul Randall) so it's less to allocate.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.