Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Can't Restore SQL Database from dead server

Created: 14 Feb 2013 • Updated: 21 Feb 2013 | 6 comments
This issue has been solved. See solution.

Hi Guys,

I have a server that went completely offline due to some hardware issues.
Anyway , I have all vaild backups for this server's SQL databases.

However, whenever I try to restore I always get this error:

 e0000f04 - The media server could not connect to the remote computer. The remote computer may not be running the Backup Exec 
Remote Agent for Windows/Linux. Make sure that the correct version of the Remote Agent is installed and running on the target computer.
For additional information regarding this error refer to link V-79-57344-3844
 
Any Ideas how I can overcome this error ?
 
Thanks
 
Symantec Backup Exec 2010 R3
SQL Server 2008 R2

Comments 6 CommentsJump to latest comment

CraigV's picture

Is this a redirected restore?

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

MSM2015's picture

Yes it is, I am trying to save it to a local storage and then restore it to another SQL server , am I doing anything wrong ?

VJware's picture

Is the Remote Agent for Windows installed on this server ? If yes, please ensure the agent service is running under a local system account & in the restore job, choose Microsoft SQL Redirection Options.

Under these options, specify the other SQL server's name. Instance field can be left blank if choosing default. Database name can be entered if you want a different name for the dB.

Choose the location of the .mdf/.ldf (Either choose a drive or the destination server's default instance directory or a folder path.

SOLUTION
CraigV's picture

...if you can get the flat files on your media server, then it should be a simple case of copying to the target SQL server and then use normal Microsoft procedures to get the DB mounted.

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

VJware's picture

If you are trying to extract SQL as flat files from the backup, then that is not possible.

MSM2015's picture

Thanks VJware , I had to rebuild a new SQL server, and then do redirected restore.

Thanks