Backup of a remote server hangs and a debug shows the last action as a SQL resource discovery

Article:TECH65039  |  Created: 2008-01-11  |  Updated: 2014-06-24  |  Article URL http://www.symantec.com/docs/TECH65039
Article Type
Technical Solution


Issue



Backup of a remote server hangs and a debug shows the last action as a SQL resource discovery


Error



Debug logs from the Media server shows the following entry:

SQL2: Attempting attach with username

 


Cause



One or more SQL Databases are corrupted on the remote machine.

 


Solution



Workaround:

Stop the Backup Exec Remote Agent Service, rename the bedssql2.dll file to bypass SQL discovery, and restart the Remote Agent Service.  
Note: This will also disable the SQL Agent functionality on that machine.

The permanent solution is to determine which database(s) are corrupt by running the SQL Diagnostics and open a support case with Microsoft to resolve the corruption issue.
 



Legacy ID



314149


Article URL http://www.symantec.com/docs/TECH65039


Terms of use for this information are found in Legal Notices