Backup of a remote server hangs and a debug shows the last action as a SQL resource discovery
Debug logs from the Media server shows the following entry:
SQL2: Attempting attach with username
One or more SQL Databases are corrupted on the remote machine.
Stop the Backup Exec Remote Agent Service, rename the bedssql2.dll file to bypass SQL discovery, and restart the Remote Agent Service.
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.