Forum Discussion

qasimhbb's avatar
qasimhbb
Level 2
10 years ago

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

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.

2012
Backing Up
Backup and Recovery
Backup Exec
Error messages
Windows Server (2003-2008)
  • qasimhbb's avatar
    qasimhbb
    10 years ago

    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.

     

     

  • AmolB's avatar
    AmolB
    Moderator
    10 years ago

    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's avatar
    pkh
    Moderator
    10 years ago

    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's avatar
    qasimhbb
    Level 2
    10 years ago

    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.