cancel
Showing results for 
Search instead for 
Did you mean: 

Restore Job Failure

Routledge1982
Level 4

I'm attempting to restore a single SQL database from LTO2 tape using Backup Exec 2010 with SQL Server Agent.

The job reaches 5% complete, and successfully restores the database files (around 11GB in size) to the desired location, but the job continues to hang at 5% complete, with a estimated time remaining of approx. 10 hours (and indicating an estimate bytes remaining of around 210 GB).

This occurs despite the fact that only one database is selected in the restore job. Grateful for any thoughts on this issue.

1 REPLY 1

ArulPrasad
Level 6
Employee

Understanding that the restore goes the original location...

>Ensure the Database Is set to Single user mode

> Close Any handles to the database (mangement console by any user is closed before restore)