PRO-TECHS
asked on
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?
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?
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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