Restoring backed-up data to a different off-site server

We run 3 servers, one of which is MS Windows 2003 Standard Server in a MS SBS domain. This server runs business-critical SQL and a raft of shared documents and backs up onto an AIT tape drive using Backup Exec 11d .  

The company wants a simple disaster recovery option for their SQL data etc using a backup server that will remain off-site and not connected directly to the domain, although the server has been joined during installation of the OS to the domain and DCPROMO run on it. It will also run Backup Exec 11d.

When I tried today to restore a backup tape to the off-site server the restore fails with an authentication error. Obviously the server that was backed up and the server I am trying to restore to are two seperate servers yet they both have the same log-on credentials for the domain account and the BE account.

What have I missed here?

 
PRO-TECHSAsked:
Who is Participating?
 
bhanukir7Connect With a Mentor Commented:
Hi,

Can you check if the user a/c that you are using to restore is a domain a/c or a local admin a/c. If you are using a domain a/c as this server is no longer connected it is not able to get authenticated which might be cauisng the authentication error. Also check if this back up had any session password which might be causing the error.

bhanu
0
 
bhanukir7Commented:
Hi,

One thing that you might have missed is the configuration of agent on the alternate sql server for the backup exec sql server and if there has been any password set for the backup job.

Check if the sql agent is running on the alternate sql server and also check if you have installed the SQL agent on the server and check if you are trying to restore to original location or did you select the alternate location.

bhanu
0
 
PRO-TECHSAuthor Commented:
Hi bhanu

I don't t think this is the problem. I'm not able to restore any files form the backup - files like Word documents and templates.

Paul
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.