Forum Discussion

mahmoudazem's avatar
mahmoudazem
Level 2
12 years ago

Final error: 0xe000848c - Unable to attach to a resource.

Good Morning all , 

 

i have an sql server that i want to backup through another sever, when i am trying to backup files and folders from the SQL its OK, BUT when trying to backup the SQL databases it returns me this error message

Completed status: Faile

"Final error: 0xe000848c - Unable to attach to a resource. Make sure that all selected resources exist and are online, and then try again. If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource.

Final error category: Resource Errors 

"

i have add the credintials for the sql server to the BE 2010 Remote agent. and nothing new. 

 

 

is there any ideas about this issue. 

 

Mahmoud Azem 

 

2010
Agents
Backing Up
Backup and Recovery
Backup Exec
Error messages
  • pkh's avatar
    pkh
    12 years ago

    To activate the SQL agent, you need to purchase a SQL Agent licence and install it in the media server.  Go to Tools --->  Install Options and Licences to do so.  Once you have installed the SQL Agent licence and select the SQL Agent option, it will be activated.  You would then see SQL as a separate section in the selection list for that server.  You can them use this section to select the databases to be backed up.

  • Gurvinder's avatar
    Gurvinder
    Moderator
    12 years ago

    Does the account used to backup SQL database has sysadmin priveledges ?

  • pkh's avatar
    pkh
    Moderator
    12 years ago

    Are you backing up the SQL databases using the SQL agent or are you selecting the .mdf files.  If it is the latter, it cannot be done because .mdf files are automatically excluded by AFE.

  • mahmoudazem's avatar
    mahmoudazem
    Level 2
    12 years ago

    Dear Gurvinder

    yes the account have the sysadmin privligies. 

     

    Dear Pkh, 

    how to stsrt the sql agent. its already installed on the BE server. 

     

    thanks for replies. 

     

  • Gurvinder's avatar
    Gurvinder
    Moderator
    12 years ago

    Launch SGMON.exe (present in BE Install Path on Media Server and RAWS Install Path on remote server). Select the first checkbox and capture to file (click on clear log) and browse the sql server and try expanding the instance to produce the error. Upload the sgmon log from media server and remote server (logs will be located at BE Install Path\logs and RAWS Install Path\logs)

  • pkh's avatar
    pkh
    Moderator
    12 years ago

    To activate the SQL agent, you need to purchase a SQL Agent licence and install it in the media server.  Go to Tools --->  Install Options and Licences to do so.  Once you have installed the SQL Agent licence and select the SQL Agent option, it will be activated.  You would then see SQL as a separate section in the selection list for that server.  You can them use this section to select the databases to be backed up.