Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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!!!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

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

Your Answer


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.