• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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
0
hennessym
Asked:
hennessym
  • 3
1 Solution
 
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:
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
 
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now