cancel
Showing results for 
Search instead for 
Did you mean: 

SQL 2000 backup successful, but restore - fail.

Dmitriy_Lykov
Level 2
BackupExec 10.0 rev 5520 don't restore sql2000 databases
Error category : Resource ErrorsError : e000848c - Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again.

We are tryed to restore all variants (in the same location, to another server etc.)
But backups databases from this SQL its OK.

How to issue this problem? Please, help me!

P.S. SQL2000 sp4 on Windows 2003 sp1 cluster 2 node
agents installed on each node.
1 REPLY 1

shweta_rege
Level 6
Hello,


The "Unable to attach to one of the drives" error occurs mostly due to permissions related issue. It may also occur if the logon account used for backup does not has the required permission. Refer to the following guidelines to resolve this issue:


1) Create a new user on the local machine (or on the remote machine, if the issue is with remote machine's backup). Make newly created user a member of Domain/local Admin group only.


2) Start Backup Exec, create a Logon account with same user name and password as that of newly created user.

You may refer to following steps:

-Start Backup Exec

-Select Tools > Wizards > Logon account wizard

-Add new logon account, type in the credential for the new account.

-Make this account a common logon account.

-Complete the wizard.

3) Create new backup job by selecting the local (or remote machine) and select this newly created account from window.

While selecting the local resource (or remote machine), if Backup Exec does not prompt for the credentials, then after selecting the remote machine | select"resource credentials" | select existing logon account | click change and select the newly created logon account.





http://seer.support.veritas.com/docs/266177.htm





Thank You,

Shweta