I am backing up a large database (2.5 GB) using SolidCP 1.3.0 and SQL Server 2012:
SolidCP > Databases > SQL Server 2012 > [Database name] > Maintenance Tools > Backup
Error message:
Stack Trace: System.Net.WebException: The operation has timed out
at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)
at Microsoft.Web.Services3.WebServicesClientProtocol.GetResponse(WebRequest request, IAsyncResult result)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.esDatabaseServers.BackupSqlDatabase(Int32 itemId, String backupName, Boolean zipBackup, Boolean download, String folderName)
at SolidCP.Portal.SqlBackupDatabase.BackupDatabase()
Additional information: I can backup databases without issue.
Hello,
I think for larger db's you will need to increase timeout values on the SQL connection string but also the existing timeout values in the web.configs
Once increased it should work as expected
Please, send me more details:
- How to increase timeout values on the SQL connection string?
- Hot to increase the existing timeout values in the web.configs?
Most easy is to check google for those but:
MSSQL Connection string you add "Connection Timeout=30" for example
For exact values on web.config it's better to just open up a web.config and check for any time sensetive values (as there's quite a few it's not easy to list them all here).
Should I updated the web.config file for "Enterprise Server" folder only? Or I'm forgetting another web.config file?
