MS SQL Server: 2016
Windows: 2012 R2
TDP for SQL / FCM: 7.1.6.5
I have an environment with 2 x servers on SQL Server 2014 and another 2 x servers on SQL Server 2016.
All are on Windows 2012 R2 + TDP for SQL 7.1.6.5.
Got a problem that on 1 of the clients (running SQL 2016), it often hangs during backup (backups run daily, it hangs 1-2 times every week). When it hangs, the only way to get it back to work is to stop TSM server to let the job dies itself, the session could not be cancelled on TSM server level, even killing the job on client, the session is still on TSM server, it still exists unless I shut down TSM server service.
If I don't kill the job, it could hang for days without dying. At first I wonder if it could be tape problems, but doesn't seem so, it could happen on different tapes, and there is no hardware problem reported. Wondering if anybody has seen something similar or any suggestion. Tried to google a bit but no luck.
Windows: 2012 R2
TDP for SQL / FCM: 7.1.6.5
I have an environment with 2 x servers on SQL Server 2014 and another 2 x servers on SQL Server 2016.
All are on Windows 2012 R2 + TDP for SQL 7.1.6.5.
Got a problem that on 1 of the clients (running SQL 2016), it often hangs during backup (backups run daily, it hangs 1-2 times every week). When it hangs, the only way to get it back to work is to stop TSM server to let the job dies itself, the session could not be cancelled on TSM server level, even killing the job on client, the session is still on TSM server, it still exists unless I shut down TSM server service.
If I don't kill the job, it could hang for days without dying. At first I wonder if it could be tape problems, but doesn't seem so, it could happen on different tapes, and there is no hardware problem reported. Wondering if anybody has seen something similar or any suggestion. Tried to google a bit but no luck.