At my work, we use Release Management (Visual Studio 2013) to deploy various websites, webservices, winservices and databases through the use of "Deploy Using PS/DSC" PowerShell scripts. Since we don't have direct access to our database servers, we have a separate template that uses PowerShell scripts to run one-time .sql scripts to fill new database tables for example. These scripts makes use of sqlcmd.exe to run the queries.
This has been working fine so far, but right now there is a particular query that takes a few hours to run. After running for just over 2 hours, the action returns as Failed, with the following message in the Log: Action timed out, setting the status as failed
I have been trying to find a place in the web.config where there is a timeout value of 2 hours, but no such luck sadly. Googling this message has left me with no useful results. I would love some advice on what the culprit might be.