Using Maintenance Tools > Backup, the backups are working fine.
Using Scheduled Task > Backup database, the backups are not working fine.
The status is “Running” until complete the “Max Execution Time”. The message error is “Thread was being aborted” in “Audit Log”
Windows Server 2012
SQL Server 2012
I get this execution log message:
Thread was being aborted.
at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
at System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean exitContext)
at System.Net.LazyAsyncResult.WaitForCompletion(Boolean snap)
at System.Net.Connection.SubmitRequest(HttpWebRequest request, Boolean forcedsubmit)
at System.Net.ServicePoint.SubmitRequest(HttpWebRequest request, String connName)
at System.Net.HttpWebRequest.SubmitRequest(ServicePoint servicePoint)
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object parameters)
at SolidCP.Providers.Database.DatabaseServer.BackupDatabase(String databaseName, String backupName, Boolean zipBackup)
at SolidCP.EnterpriseServer.DatabaseServerController.BackupSqlDatabase(Int32 itemId, String backupName, Boolean zipBackup, Boolean download, String folderName)
No, Trevor. The databases are litle as 30mb, 50mb, 200mb, etc
Manually I can do it the backup using Maintenance Tools > Backup but using Scheduled Task > Backup database, not works.
This very strange because permissions and connection with the sql server is fine.
In your live server, do you have installed the last version with the build 6/28/2017?
I have tried it on the first release of 1.2.1 (5/27/2017) and also the latest version of the source code which runs on our development environment.
You could try increase the logging on the database servers SolidCP Server web.config to see if it is able to give you more details?
Thanks for your help!
The problem was in the server configuration. The backups using scheduled tasks are working fine now.