cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to attach to SAPB.domain.com\MSSQLSERVER.

qasimhbb
Level 2

I am having issues with backup exec 2012. it fails to complete the backup and gives the following erorr,

V-79-57344-33932 - 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.

 

I checked the services. mssql is running on the server, I checked the passwords, they are fine. Job log gives this error,

 

Unable to attach to SAPB.domain.com\MSSQLSERVER.

 

Please help in resolving this issue.

1 ACCEPTED SOLUTION

Accepted Solutions

qasimhbb
Level 2

Thank you all for your support and answers.

The solution which I had is that the MSSQLSERVER service was not running on the server. for some odd reason, the service was shut down. I restarted the services manually and then everything is working fine now.

 

 

View solution in original post

3 REPLIES 3

AmolB
Moderator
Moderator
Employee Accredited Certified

Refer to the below article.

http://www.symantec.com/docs/TECH71780

Also check below article for the permissions required to backup SQL.

http://www.symantec.com/business/support/index?page=content&id=TECH130255#SQL_Agent

pkh
Moderator
Moderator
   VIP    Certified

As an aside, if you are backing up a SAP database using the SQL Server agent, do read my article below

https://www-secure.symantec.com/connect/blogs/can-i-backup-sap-database-sql-or-oracle-agent

qasimhbb
Level 2

Thank you all for your support and answers.

The solution which I had is that the MSSQLSERVER service was not running on the server. for some odd reason, the service was shut down. I restarted the services manually and then everything is working fine now.