My SQL serving is working fine but when I try to backup with SQLBackupandFTP I get the following error message:
“SQLBackupandFTP (SQL server backup) windows service has stopped. See Windows eventlog to find the reason. Restart the service to resume backup jobs.”
I am running version 12.3.11 on Windows 10.
I have gone to Computer Management. I found the SQLBackupAndFtp Client service was not running. I started the service but within 1 to 2 seconds the service stops again. I can watch Windows start the service, say its running for about a second and stop again. It will do this about every 10 seconds (at least while I am watching it in the Computer Management app.)
I searched the Windows Event log and found that SQLBackupAndFTP Client Service had tried and failed to start over 147 times since March 26th.
Windows did a “Cumulative update for Windows 10” on my computer March 25 and the Windows event log starts showing the errors for SQLBackupand FTP on the 26th.
After attempting to restart the client services again I get these errors:
SQLBackupAndFTP Client services
An exception occurred during the operation, making the result invalid. Check InnerException for exception details. > Could not load file or assembly ‘System.Data.SQLite, Version=1.0.112.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
>NET Runtime
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileLoadException
at Net.Pranas.SqlBak.Context.Context.Data.DatabaseHandler.CreateDbConnectionEx()
at Net.Pranas.SqlBak.Context.Context.Data.DatabaseHandler.UpdateDatabase()
at Net.Pranas.SqlBak.Context.Context.Data.DatabaseHandler.UpdateDatabaseToLastVersion(Net.Pranas.SqlBak.Context.Context.Data.DatabaseHandler)
at Net.Pranas.SqlBak.Context.Context.Data.DatabaseHandler…ctor(System.Nullable1<Boolean>, System.Nullable
1)
at Net.Pranas.SqlBak.Context.Context.Data.ContextDatabaseHandler…ctor(Net.Pranas.SqlBak.Context.Context.Data.ContextHandler)
at Pranas.Net.SqlBak.Service.Context.ServiceContext.get_IsLocal()
at Pranas.Net.SqlBak.Service.Context.ServiceContext.get_AccountContentService()
at Pranas.Net.SqlBak.Service.Context.ServiceContext+<>c__DisplayClass17_0.b__0(System.Object, System.ComponentModel.DoWorkEventArgs)
at System.ComponentModel.BackgroundWorker.OnDoWork(System.ComponentModel.DoWorkEventArgs)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(System.Object)Exception Info: System.Reflection.TargetInvocationException
at System.ComponentModel.AsyncCompletedEventArgs.RaiseExceptionIfNecessary()
at Pranas.Net.SqlBak.Service.Context.ServiceContext+<>c__DisplayClass17_0.b__1(System.Object, System.ComponentModel.RunWorkerCompletedEventArgs)
at System.ComponentModel.BackgroundWorker.OnRunWorkerCompleted(System.ComponentModel.RunWorkerCompletedEventArgs)
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
at System.Threading.ThreadPoolWorkQueue.Dispatch()
Application Error
Faulting application name: SqlBak.Service.exe, version: 2.14.7.0, time stamp: 0x5e70ea64
Faulting module name: KERNELBASE.dll, version: 10.0.18362.752, time stamp: 0x2023e189
Exception code: 0xe0434352
Fault offset: 0x000000000003a859
Faulting process id: 0x3378
Faulting application start time: 0x01d6092bcfce9db4
Faulting application path: C:\Program Files (x86)\SQLBackupAndFTP\SqlBak.Service.exe
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
Report Id: 0cf53b8f-8737-4778-8a56-807b43991675
Faulting package full name:
Faulting package-relative application ID:
Can someone help me get the SQLBackupAndFTP Client services running again?
Dave