Video Screencast Help
Search Video Help Close Back
to help

restore a database to a different server

Created: 24 Oct 2012 | Updated: 29 Oct 2012 | 12 comments
kakagol's picture
0 0 Votes
Login to vote
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

Comments 12 CommentsJump to latest comment

kakagol's picture

I keep receiving this error:

 

The job failed with the following error: To restore over an existing SQL server database, ensure that the option 'Overwrite the existing database' is enabled on the Restore Job Properties.
 
I dont understand it, it shoudnt be enabled as I am restoring on a disk....
0
Login to vote
  • Actions
CraigV's picture

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.

+1
Login to vote
  • Actions
kakagol's picture

Thanks, 

in case I choose to redirect it to a different server, does it need to have SQL installed? Same version?

0
Login to vote
  • Actions
CraigV's picture

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.

+1
Login to vote
  • Actions
kakagol's picture

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.....)

0
Login to vote
  • Actions
CraigV's picture

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.

+1
Login to vote
  • Actions
kakagol's picture

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, 

 

To establish a trust relationship, add the remote agent to the Favorite Resources in the backup selections tree.
 
?
0
Login to vote
  • Actions
CraigV's picture

...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.

+1
Login to vote
  • Actions
kakagol's picture

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...

 

0
Login to vote
  • Actions
CraigV's picture

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.

+1
Login to vote
  • Actions
kakagol's picture

both ping -a test and nslookup test are OK.

0
Login to vote
  • Actions
kakagol's picture

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

SOLUTION
+1
Login to vote
  • Actions