10-24-2012 08:31 AM
Hello,
I need to restore some data from a database on to a different server.
Does the other server need SQL installed? Or can it be restore it as a file?
If it needs SQL installed, does it need the same version ?
Thank much appreciated
Solved! Go to Solution.
10-29-2012 10:42 AM
found it.
Seems like it has always been there. I added the server to the device panel list using "Configure Remote Agent for Deduplication"
Thanks again for your help
10-24-2012 09:36 AM
I keep receiving this error:
10-24-2012 11:47 AM
You can try duplicating the SQL backup to disk, but ideally you are looking at restoring to the same SQL server, or redirecting to another.
Thanks!
10-24-2012 11:19 PM
Thanks,
in case I choose to redirect it to a different server, does it need to have SQL installed? Same version?
10-24-2012 11:23 PM
Well, how do you redirect a SQL restore to a SQL server without SQL installed? So yes, it needs to have SQL installed, and yes, it must be the same version to rule out incompatibilities.
I'd also suggest reading the BE Admin Guide for further information on restoring SQL DBs.
Thanks!
10-24-2012 11:34 PM
I thought there could be a way to restore the DB as a file, and then restoring it to SQL using the SSMS restore config...
(I thought it was as simple as restoring a file/folder.....)
10-24-2012 11:47 PM
Read below:
https://www-secure.symantec.com/connect/forums/restoring-sql#comment-7044881
As I mentioned, you cann't restore SQL as a flat-file like you can with Exchange (GRT backups to tape can be duplicated to disk to get the *.edb). You need SQL installed on the target server.
10-25-2012 04:49 AM
Thanks again Craig,
I have choosen a doable server and installed same SQL version. Also installed the Backup-Exec agent.
When launching the restore I receive the error,
10-25-2012 04:55 AM
...check below for this error:
http://www.symantec.com/business/support/index?page=content&id=TECH159323
Thanks!
10-25-2012 05:50 AM
Thanks again Craig,
I have followed both 1 and 2.
1 Installed it from the server.
2 Installed it locally using RAWS install
The agent is installed on the client but it is not listed on the server, if I browse to Device tab it is not there. I have also restarted services/application/server, but no luck...
10-29-2012 04:33 AM
OK, then try the following:
1. On both the media server and the remote server, run a ping -a to resolve name/IP.
2. Run an nslookup on each of these servers...
This rules out DNS issues if the don't exist.
10-29-2012 09:57 AM
both ping -a test and nslookup test are OK.
10-29-2012 10:42 AM
found it.
Seems like it has always been there. I added the server to the device panel list using "Configure Remote Agent for Deduplication"
Thanks again for your help