I have AIP scanner job scanning around 114 repository. Scan job runs perfectly for first 20+ days. After that i see SQL exception in AIPscanner log and the 'TotalScannedFiles' is either 0 or same count repeats.
Then i had to create a new Database instance, start scan and again SQL error comes up in log after 20+ days. This has been the trend for last 4 months. PFB SQL error trace log and let me know a solution to overcome this so that scan job can get completed.
"System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
NOTE: MSSQL timeout is set to 0. There was no server reboot or service restart done when scan job was running.