restore a database to a different server
Created: 24 Oct 2012 | Updated: 29 Oct 2012 | 12 comments
This issue has been solved. See solution.
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
Discussion Filed Under:
Comments 12 Comments • Jump to latest comment
I keep receiving this error:
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!
If you find this is a solution, please mark it as such.
Thanks,
in case I choose to redirect it to a different server, does it need to have SQL installed? Same version?
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!
If you find this is a solution, please mark it as such.
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.....)
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.
If you find this is a solution, please mark it as such.
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,
...check below for this error:
http://www.symantec.com/business/support/index?page=content&id=TECH159323
Thanks!
If you find this is a solution, please mark it as such.
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...
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.
If you find this is a solution, please mark it as such.
both ping -a test and nslookup test are OK.
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
Would you like to reply?
Login or Register to post your comment.