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
SQL Server 2008 R2
Discussion Filed Under:
Comments 6 Comments • Jump to latest comment
Is this a redirected restore?
If you find this is a solution, please mark it as such.
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 ?
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.
...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!
If you find this is a solution, please mark it as such.
If you are trying to extract SQL as flat files from the backup, then that is not possible.
Thanks VJware , I had to rebuild a new SQL server, and then do redirected restore.
Thanks
Would you like to reply?
Login or Register to post your comment.