Video Screencast Help

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

Created: 16 Jan 2013 • Updated: 16 Mar 2013 | 5 comments
mahmoudazem's picture
This issue has been solved. See solution.

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 

 

Comments 5 CommentsJump to latest comment

Gurvinder Rait's picture

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

pkh's picture

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 picture

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 Rait's picture

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 picture

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.

SOLUTION