Restore Database Progress Bar

I started a restore of a 150 GB database about 12 hours ago via Enterprise Manager.  The progress bar has moved all the way to the end, but the task has not completed.

I just want to confirm this is normal behavior?

Thanks - Matt
LVL 1
hennessymAsked:
Who is Participating?
 
Kevin3NFConnect With a Mentor Commented:
Assuming SQL 2000, when did it get to the end?

Does the Current Activity show that it is still working?

Select * from master..sysprocesses where kpid >0
--this should show a restore database command in process.  If the physical IO number is changing, its still working
0
 
matrix_aashCommented:
I am sure it will ok. It does take sometime sometimes have you checked in the task manager if its still running and give  highest priority to the task?
0
 
Kevin3NFCommented:
the task manager will only show the sqlservr.exe, not the restore command
0
 
hennessymAuthor Commented:
Thanks, Kevin.

The physical IO appears stuck at 1744660.

The cpu is changing, from 242548 to 242564 to 242580.  In the SQL Server event log, I see "SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file."  I'm assuming the best course of action is to abort the restore and try again?

Thanks again - Matt
0
 
Kevin3NFCommented:
when you see "SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file", you may have some serious disk issues.  Check that out first.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.