Environment
- Product and version(s) affected: OpenText Data Protector (version A.11.01)
- Platform: Microsoft SQL Server, Windows Server (2012 R2 or similar)
Situation
The backup job hangs without detailed error messages, particularly when backing up multiple instances under the same database. The job fails to complete for one instance while others complete successfully. The job shows a message indicating it is "waiting for databases to unlock."
Cause
The issue is caused by orphaned sql_bar
processes on the client machine hosting the SQL instance. These processes prevent the backup job from completing successfully by causing it to hang while waiting for the database to unlock.