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

Problem

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

Error Message

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.
 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)