TFS Back up failed : Timeout expired

I am trying to take the tfs back up. But its getting failed .

I will add the exception details here from the log file generated .

[Error @12:41:51.187] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'sampledb-tfs-ser'. ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Microsoft.SqlServer.Management.Common.Connect开发者_C百科ionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

I know server is timing out . is der any way to increase the time out or any other way in which this problem could be solved ..?

Can any one help please ...?

Looks like you're using some sort of programming language (C#, powershell, etc) to do this. You're going to have to set the query timeout for your connection to 0 to let the program wait indefinitely for the backup to finish. How you go about doing that depends on the language, The ServerConnection class has a property called StatementTimeout. Set that to 0 and you should be good to go.

On your TFS APPTier server, in file C:\ProgramData\Microsoft\Team Foundation\Server Configuration\ConfigPT.xml , try changing the value of property

<SqlStatementTimeoutInSeconds>21600</SqlStatementTimeoutInSeconds>

Try 12 hours (43200) instead. That solved the problem for me.

This file is the result of executing the TFS backup plan in the "Team Foundation Administration Console". Therefore you may have to change that value everytime after re-executing the TFS backup plan.