OK, so I tried this again, allowed it to retry twice and cancelled it and tried to capture most of a live log, LMK if it’s helpful:
{"ClassName":"System.Threading.ThreadAbortException","Message":"Thread was being aborted.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at Duplicati.Library.Main.AsyncDownloader.AsyncDownloaderEnumerator.MoveNext()\r\n at Duplicati.Library.Main.Operation.RestoreHandler.DoRun(LocalDatabase dbparent, IFilter filter, RestoreResults result)\r\n at Duplicati.Library.Main.Operation.RestoreHandler.Run(String[] paths, IFilter filter)\r\n at Duplicati.Library.Main.Controller.<>c__DisplayClass14_0.<Restore>b__0(RestoreResults result)\r\n at Duplicati.Library.Main.Controller.RunAction[T](T result, String[]& paths, IFilter& filter, Action`1 method)\r\n at Duplicati.Library.Main.Controller.Restore(String[] paths, IFilter filter)\r\n at Duplicati.Server.Runner.Run(IRunnerData data, Boolean fromQueue)","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\nMoveNext\nDuplicati.Library.Main, Version=2.0.4.12, Culture=neutral, PublicKeyToken=null\nDuplicati.Library.Main.AsyncDownloader+AsyncDownloaderEnumerator\nBoolean MoveNext()","HResult":-2146233040,"Source":"Duplicati.Library.Main","WatsonBuckets":null}
* Mar 15, 2019 9:34 AM: Running Restore took 0:00:01:42.561
* Mar 15, 2019 9:34 AM: Operation Get with file duplicati-b9522954b15c74218bb6c899315c3b53e.dblock.zip.aes attempt 3 of 5 failed with message: Thread was being aborted.
{"ClassName":"System.Threading.ThreadAbortException","Message":"Thread was being aborted.","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at System.Threading.Thread.AbortInternal()\r\n at System.Threading.Thread.Abort()\r\n at Duplicati.Library.Main.BasicResults.TaskControlRendevouz()\r\n at Duplicati.Library.Main.BackendManager.ThreadRun()\r\n at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)\r\n at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)\r\n at System.Threading.ThreadHelper.ThreadStart()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\nAbortInternal\nmscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\nSystem.Threading.Thread\nVoid AbortInternal()","HResult":-2146233040,"Source":"mscorlib","WatsonBuckets":null}
* Mar 15, 2019 9:34 AM: Backend event: Get - Retrying: duplicati-b9522954b15c74218bb6c899315c3b53e.dblock.zip.aes (49.91 MB)
* Mar 15, 2019 9:34 AM: Operation Get with file duplicati-b9522954b15c74218bb6c899315c3b53e.dblock.zip.aes attempt 2 of 5 failed with message: Failed to decrypt data (invalid passphrase?): Invalid password or corrupted data
{"ClassName":"System.Security.Cryptography.CryptographicException","Message":"Failed to decrypt data (invalid passphrase?): Invalid password or corrupted data","Data":null,"InnerException":{"ClassName":"SharpAESCrypt.SharpAESCrypt+WrongPasswordException","Message":"Invalid password or corrupted data","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at SharpAESCrypt.SharpAESCrypt.ReadEncryptionHeader(String password, Boolean skipFileSizeCheck)\r\n at SharpAESCrypt.SharpAESCrypt..ctor(String password, Stream stream, OperationMode mode, Boolean skipFileSizeCheck)\r\n at Duplicati.Library.Encryption.AESEncryption.Decrypt(Stream input)\r\n at Duplicati.Library.Encryption.EncryptionBase.Decrypt(Stream input, Stream output)","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\nReadEncryptionHeader\nSharpAESCrypt, Version=1.3.1.0, Culture=neutral, PublicKeyToken=da45da0a7b8da0d2\nSharpAESCrypt.SharpAESCrypt\nVoid ReadEncryptionHeader(System.String, Boolean)","HResult":-2146233296,"Source":"SharpAESCrypt","WatsonBuckets":null},"HelpURL":null,"StackTraceString":" at Duplicati.Library.Main.BackendManager.coreDoGetPiping(FileEntryItem item, IEncryption useDecrypter, Int64& retDownloadSize, String& retHashcode)\r\n at Duplicati.Library.Main.BackendManager.DoGet(FileEntryItem item)\r\n at Duplicati.Library.Main.BackendManager.ThreadRun()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\ncoreDoGetPiping\nDuplicati.Library.Main, Version=2.0.4.12, Culture=neutral, PublicKeyToken=null\nDuplicati.Library.Main.BackendManager\nDuplicati.Library.Utility.TempFile coreDoGetPiping(FileEntryItem, Duplicati.Library.Interface.IEncryption, Int64 ByRef, System.String ByRef)","HResult":-2146233296,"Source":"Duplicati.Library.Main","WatsonBuckets":null}
* Mar 15, 2019 9:34 AM: RemoteOperationGet took 0:00:00:35.690
* Mar 15, 2019 9:33 AM: Backend event: Get - Started: duplicati-b9522954b15c74218bb6c899315c3b53e.dblock.zip.aes (49.91 MB)
* Mar 15, 2019 9:33 AM: Starting - RemoteOperationGet
* Mar 15, 2019 9:33 AM: Backend event: Get - Retrying: duplicati-b9522954b15c74218bb6c899315c3b53e.dblock.zip.aes (49.91 MB)
* Mar 15, 2019 9:33 AM: Operation Get with file duplicati-b9522954b15c74218bb6c899315c3b53e.dblock.zip.aes attempt 1 of 5 failed with message: Failed to decrypt data (invalid passphrase?): Invalid password or corrupted data
{"ClassName":"System.Security.Cryptography.CryptographicException","Message":"Failed to decrypt data (invalid passphrase?): Invalid password or corrupted data","Data":null,"InnerException":{"ClassName":"SharpAESCrypt.SharpAESCrypt+WrongPasswordException","Message":"Invalid password or corrupted data","Data":null,"InnerException":null,"HelpURL":null,"StackTraceString":" at SharpAESCrypt.SharpAESCrypt.ReadEncryptionHeader(String password, Boolean skipFileSizeCheck)\r\n at SharpAESCrypt.SharpAESCrypt..ctor(String password, Stream stream, OperationMode mode, Boolean skipFileSizeCheck)\r\n at Duplicati.Library.Encryption.AESEncryption.Decrypt(Stream input)\r\n at Duplicati.Library.Encryption.EncryptionBase.Decrypt(Stream input, Stream output)","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\nReadEncryptionHeader\nSharpAESCrypt, Version=1.3.1.0, Culture=neutral, PublicKeyToken=da45da0a7b8da0d2\nSharpAESCrypt.SharpAESCrypt\nVoid ReadEncryptionHeader(System.String, Boolean)","HResult":-2146233296,"Source":"SharpAESCrypt","WatsonBuckets":null},"HelpURL":null,"StackTraceString":" at Duplicati.Library.Main.BackendManager.coreDoGetPiping(FileEntryItem item, IEncryption useDecrypter, Int64& retDownloadSize, String& retHashcode)\r\n at Duplicati.Library.Main.BackendManager.DoGet(FileEntryItem item)\r\n at Duplicati.Library.Main.BackendManager.ThreadRun()","RemoteStackTraceString":null,"RemoteStackIndex":0,"ExceptionMethod":"8\ncoreDoGetPiping\nDuplicati.Library.Main, Version=2.0.4.12, Culture=neutral, PublicKeyToken=null\nDuplicati.Library.Main.BackendManager\nDuplicati.Library.Utility.TempFile coreDoGetPiping(FileEntryItem, Duplicati.Library.Interface.IEncryption, Int64 ByRef, System.String ByRef)","HResult":-2146233296,"Source":"Duplicati.Library.Main","WatsonBuckets":null}
* Mar 15, 2019 9:33 AM: RemoteOperationGet took 0:00:00:33.939
* Mar 15, 2019 9:33 AM: Backend event: Get - Started: duplicati-b9522954b15c74218bb6c899315c3b53e.dblock.zip.aes (49.91 MB)
* Mar 15, 2019 9:33 AM: Starting - RemoteOperationGet
* Mar 15, 2019 9:33 AM: 3 remote files are required to restore
* Mar 15, 2019 9:33 AM: GetMissingVolumes took 0:00:00:00.001
* Mar 15, 2019 9:33 AM: Starting - GetMissingVolumes
* Mar 15, 2019 9:33 AM: ScanForExistingSourceBlocksFast took 0:00:00:00.078
* Mar 15, 2019 9:33 AM: CommitBlockMarker took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - CommitBlockMarker
* Mar 15, 2019 9:33 AM: Target file is patched with some local data: C:\Users\Jay\Desktop\Alex Database - Current as at Sept. '11.2019-02-07.accdb
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT DISTINCT "Fileset-E223E078E1415E45B54CD4503D74991A"."TargetPath", "Fileset-E223E078E1415E45B54CD4503D74991A"."Path", "Fileset-E223E078E1415E45B54CD4503D74991A"."ID", "Blocks-E223E078E1415E45B54CD4503D74991A"."Index", "Blocks-E223E078E1415E45B54CD4503D74991A"."Hash", "Blocks-E223E078E1415E45B54CD4503D74991A"."Size" FROM "Fileset-E223E078E1415E45B54CD4503D74991A", "Blocks-E223E078E1415E45B54CD4503D74991A", "File", (SELECT "File"."Path", "File"."BlocksetID", MAX("Fileset"."Timestamp") FROM "Fileset", "FilesetEntry", "File" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "FilesetEntry"."FilesetID" = "Fileset"."ID" AND "File"."Path" IN (SELECT DISTINCT "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" FROM "Fileset-E223E078E1415E45B54CD4503D74991A", "Blocks-E223E078E1415E45B54CD4503D74991A" WHERE "Fileset-E223E078E1415E45B54CD4503D74991A"."ID" = "Blocks-E223E078E1415E45B54CD4503D74991A"."FileID" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Restored" = 0 AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Metadata" = 0 AND "Fileset-E223E078E1415E45B54CD4503D74991A"."TargetPath" != "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" ) GROUP BY "File"."Path" ) S, "Block", "BlocksetEntry" WHERE "BlocksetEntry"."BlocksetID" = "S"."BlocksetID" AND "BlocksetEntry"."BlocksetID" = "File"."BlocksetID" AND "BlocksetEntry"."BlockID" = "Block"."ID" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Index" = "BlocksetEntry"."Index" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Hash" = "Block"."Hash" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Size" = "Block"."Size" AND "S"."Path" = "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" AND "Fileset-E223E078E1415E45B54CD4503D74991A"."ID" = "Blocks-E223E078E1415E45B54CD4503D74991A"."FileID" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Restored" = 0 AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Metadata" = 0 AND "Fileset-E223E078E1415E45B54CD4503D74991A"."TargetPath" != "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" ORDER BY "Fileset-E223E078E1415E45B54CD4503D74991A"."ID", "Blocks-E223E078E1415E45B54CD4503D74991A"."Index" took 0:00:00:00.002
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT DISTINCT "Fileset-E223E078E1415E45B54CD4503D74991A"."TargetPath", "Fileset-E223E078E1415E45B54CD4503D74991A"."Path", "Fileset-E223E078E1415E45B54CD4503D74991A"."ID", "Blocks-E223E078E1415E45B54CD4503D74991A"."Index", "Blocks-E223E078E1415E45B54CD4503D74991A"."Hash", "Blocks-E223E078E1415E45B54CD4503D74991A"."Size" FROM "Fileset-E223E078E1415E45B54CD4503D74991A", "Blocks-E223E078E1415E45B54CD4503D74991A", "File", (SELECT "File"."Path", "File"."BlocksetID", MAX("Fileset"."Timestamp") FROM "Fileset", "FilesetEntry", "File" WHERE "FilesetEntry"."FileID" = "File"."ID" AND "FilesetEntry"."FilesetID" = "Fileset"."ID" AND "File"."Path" IN (SELECT DISTINCT "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" FROM "Fileset-E223E078E1415E45B54CD4503D74991A", "Blocks-E223E078E1415E45B54CD4503D74991A" WHERE "Fileset-E223E078E1415E45B54CD4503D74991A"."ID" = "Blocks-E223E078E1415E45B54CD4503D74991A"."FileID" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Restored" = 0 AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Metadata" = 0 AND "Fileset-E223E078E1415E45B54CD4503D74991A"."TargetPath" != "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" ) GROUP BY "File"."Path" ) S, "Block", "BlocksetEntry" WHERE "BlocksetEntry"."BlocksetID" = "S"."BlocksetID" AND "BlocksetEntry"."BlocksetID" = "File"."BlocksetID" AND "BlocksetEntry"."BlockID" = "Block"."ID" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Index" = "BlocksetEntry"."Index" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Hash" = "Block"."Hash" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Size" = "Block"."Size" AND "S"."Path" = "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" AND "Fileset-E223E078E1415E45B54CD4503D74991A"."ID" = "Blocks-E223E078E1415E45B54CD4503D74991A"."FileID" AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Restored" = 0 AND "Blocks-E223E078E1415E45B54CD4503D74991A"."Metadata" = 0 AND "Fileset-E223E078E1415E45B54CD4503D74991A"."TargetPath" != "Fileset-E223E078E1415E45B54CD4503D74991A"."Path" ORDER BY "Fileset-E223E078E1415E45B54CD4503D74991A"."ID", "Blocks-E223E078E1415E45B54CD4503D74991A"."Index"
* Mar 15, 2019 9:33 AM: Starting - ScanForExistingSourceBlocksFast
* Mar 15, 2019 9:33 AM: ScanForExistingTargetBlocks took 0:00:00:00.006
* Mar 15, 2019 9:33 AM: CommitBlockMarker took 0:00:00:00.001
* Mar 15, 2019 9:33 AM: Starting - CommitBlockMarker
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: UPDATE "Fileset-E223E078E1415E45B54CD4503D74991A" SET "TargetPath" = "C:\Users\Jay\Desktop\Alex Database - Current as at Sept. '11.2019-02-07.accdb" WHERE "ID" = 1 took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: UPDATE "Fileset-E223E078E1415E45B54CD4503D74991A" SET "TargetPath" = "C:\Users\Jay\Desktop\Alex Database - Current as at Sept. '11.2019-02-07.accdb" WHERE "ID" = 1
* Mar 15, 2019 9:33 AM: Target file exists and will be restored to: C:\Users\Jay\Desktop\Alex Database - Current as at Sept. '11.2019-02-07.accdb
* Mar 15, 2019 9:33 AM: Starting - ScanForExistingTargetBlocks
* Mar 15, 2019 9:33 AM: CreateDirectory took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT "TargetPath" FROM "Fileset-E223E078E1415E45B54CD4503D74991A" WHERE "BlocksetID" == -100 took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT "TargetPath" FROM "Fileset-E223E078E1415E45B54CD4503D74991A" WHERE "BlocksetID" == -100
* Mar 15, 2019 9:33 AM: Starting - CreateDirectory
* Mar 15, 2019 9:33 AM: PrepareBlockList took 0:00:00:00.022
* Mar 15, 2019 9:33 AM: CreateProgressTracker took 0:00:00:00.004
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE TEMPORARY TRIGGER "UpdateTotalStats_FileProgress-860C0FE1A17656448D535DDC236F7F27" AFTER UPDATE ON "FileProgress-860C0FE1A17656448D535DDC236F7F27" BEGIN UPDATE "TotalProgress-860C0FE1A17656448D535DDC236F7F27" SET "FilesFullyRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."FilesFullyRestored" + (CASE WHEN NEW."BlocksRestored" = NEW."TotalBlocks" THEN 1 ELSE 0 END) - (CASE WHEN OLD."BlocksRestored" = OLD."TotalBlocks" THEN 1 ELSE 0 END) , "FilesPartiallyRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."FilesPartiallyRestored" + (CASE WHEN NEW."BlocksRestored" BETWEEN 1 AND NEW."TotalBlocks" - 1 THEN 1 ELSE 0 END) - (CASE WHEN OLD."BlocksRestored" BETWEEN 1 AND OLD."TotalBlocks" - 1 THEN 1 ELSE 0 END) , "BlocksRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."BlocksRestored" + NEW."BlocksRestored" - OLD."BlocksRestored" , "SizeRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."SizeRestored" + NEW."SizeRestored" - OLD."SizeRestored" ; END took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TRIGGER "UpdateTotalStats_FileProgress-860C0FE1A17656448D535DDC236F7F27" AFTER UPDATE ON "FileProgress-860C0FE1A17656448D535DDC236F7F27" BEGIN UPDATE "TotalProgress-860C0FE1A17656448D535DDC236F7F27" SET "FilesFullyRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."FilesFullyRestored" + (CASE WHEN NEW."BlocksRestored" = NEW."TotalBlocks" THEN 1 ELSE 0 END) - (CASE WHEN OLD."BlocksRestored" = OLD."TotalBlocks" THEN 1 ELSE 0 END) , "FilesPartiallyRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."FilesPartiallyRestored" + (CASE WHEN NEW."BlocksRestored" BETWEEN 1 AND NEW."TotalBlocks" - 1 THEN 1 ELSE 0 END) - (CASE WHEN OLD."BlocksRestored" BETWEEN 1 AND OLD."TotalBlocks" - 1 THEN 1 ELSE 0 END) , "BlocksRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."BlocksRestored" + NEW."BlocksRestored" - OLD."BlocksRestored" , "SizeRestored" = "TotalProgress-860C0FE1A17656448D535DDC236F7F27"."SizeRestored" + NEW."SizeRestored" - OLD."SizeRestored" ; END
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE TEMPORARY TRIGGER "TrackRestoredBlocks_Blocks-E223E078E1415E45B54CD4503D74991A" AFTER UPDATE OF "Restored" ON "Blocks-E223E078E1415E45B54CD4503D74991A" WHEN OLD."Restored" != NEW."Restored" AND NEW."Metadata" = 0 BEGIN UPDATE "FileProgress-860C0FE1A17656448D535DDC236F7F27" SET "BlocksRestored" = "FileProgress-860C0FE1A17656448D535DDC236F7F27"."BlocksRestored" + (NEW."Restored" - OLD."Restored") , "SizeRestored" = "FileProgress-860C0FE1A17656448D535DDC236F7F27"."SizeRestored" + ((NEW."Restored" - OLD."Restored") * NEW.Size) WHERE "FileProgress-860C0FE1A17656448D535DDC236F7F27"."FileId" = NEW."FileID" ; END took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TRIGGER "TrackRestoredBlocks_Blocks-E223E078E1415E45B54CD4503D74991A" AFTER UPDATE OF "Restored" ON "Blocks-E223E078E1415E45B54CD4503D74991A" WHEN OLD."Restored" != NEW."Restored" AND NEW."Metadata" = 0 BEGIN UPDATE "FileProgress-860C0FE1A17656448D535DDC236F7F27" SET "BlocksRestored" = "FileProgress-860C0FE1A17656448D535DDC236F7F27"."BlocksRestored" + (NEW."Restored" - OLD."Restored") , "SizeRestored" = "FileProgress-860C0FE1A17656448D535DDC236F7F27"."SizeRestored" + ((NEW."Restored" - OLD."Restored") * NEW.Size) WHERE "FileProgress-860C0FE1A17656448D535DDC236F7F27"."FileId" = NEW."FileID" ; END
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: INSERT INTO "TotalProgress-860C0FE1A17656448D535DDC236F7F27" ( "TotalFiles", "TotalBlocks", "TotalSize" , "FilesFullyRestored", "FilesPartiallyRestored", "BlocksRestored", "SizeRestored" ) SELECT IFNULL(COUNT("P"."FileId"), 0), IFNULL(SUM("P"."TotalBlocks"), 0), IFNULL(SUM("P"."TotalSize"), 0) , IFNULL(COUNT(CASE WHEN "P"."BlocksRestored" = "P"."TotalBlocks" THEN 1 ELSE NULL END), 0) , IFNULL(COUNT(CASE WHEN "P"."BlocksRestored" BETWEEN 1 AND "P"."TotalBlocks" - 1 THEN 1 ELSE NULL END), 0) , IFNULL(SUM("P"."BlocksRestored"), 0), IFNULL(SUM("P"."SizeRestored"), 0) FROM "FileProgress-860C0FE1A17656448D535DDC236F7F27" "P" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: INSERT INTO "TotalProgress-860C0FE1A17656448D535DDC236F7F27" ( "TotalFiles", "TotalBlocks", "TotalSize" , "FilesFullyRestored", "FilesPartiallyRestored", "BlocksRestored", "SizeRestored" ) SELECT IFNULL(COUNT("P"."FileId"), 0), IFNULL(SUM("P"."TotalBlocks"), 0), IFNULL(SUM("P"."TotalSize"), 0) , IFNULL(COUNT(CASE WHEN "P"."BlocksRestored" = "P"."TotalBlocks" THEN 1 ELSE NULL END), 0) , IFNULL(COUNT(CASE WHEN "P"."BlocksRestored" BETWEEN 1 AND "P"."TotalBlocks" - 1 THEN 1 ELSE NULL END), 0) , IFNULL(SUM("P"."BlocksRestored"), 0), IFNULL(SUM("P"."SizeRestored"), 0) FROM "FileProgress-860C0FE1A17656448D535DDC236F7F27" "P"
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: INSERT INTO "FileProgress-860C0FE1A17656448D535DDC236F7F27" ("FileId", "TotalBlocks", "TotalSize", "BlocksRestored", "SizeRestored") SELECT "F"."ID", IFNULL(COUNT("B"."ID"), 0), IFNULL(SUM("B"."Size"), 0) , IFNULL(COUNT(CASE "B"."Restored" WHEN 1 THEN "B"."ID" ELSE NULL END), 0) , IFNULL(SUM(CASE "B"."Restored" WHEN 1 THEN "B"."Size" ELSE 0 END), 0) FROM "Fileset-E223E078E1415E45B54CD4503D74991A" "F" LEFT JOIN "Blocks-E223E078E1415E45B54CD4503D74991A" "B" ON "B"."FileID" = "F"."ID" WHERE "B"."Metadata" IS NOT 1 GROUP BY "F"."ID" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: INSERT INTO "FileProgress-860C0FE1A17656448D535DDC236F7F27" ("FileId", "TotalBlocks", "TotalSize", "BlocksRestored", "SizeRestored") SELECT "F"."ID", IFNULL(COUNT("B"."ID"), 0), IFNULL(SUM("B"."Size"), 0) , IFNULL(COUNT(CASE "B"."Restored" WHEN 1 THEN "B"."ID" ELSE NULL END), 0) , IFNULL(SUM(CASE "B"."Restored" WHEN 1 THEN "B"."Size" ELSE 0 END), 0) FROM "Fileset-E223E078E1415E45B54CD4503D74991A" "F" LEFT JOIN "Blocks-E223E078E1415E45B54CD4503D74991A" "B" ON "B"."FileID" = "F"."ID" WHERE "B"."Metadata" IS NOT 1 GROUP BY "F"."ID"
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE TEMPORARY TABLE "TotalProgress-860C0FE1A17656448D535DDC236F7F27" ( "TotalFiles" INTEGER NOT NULL, "TotalBlocks" INTEGER NOT NULL, "TotalSize" INTEGER NOT NULL , "FilesFullyRestored" INTEGER NOT NULL, "FilesPartiallyRestored" INTEGER NOT NULL , "BlocksRestored" INTEGER NOT NULL, "SizeRestored" INTEGER NOT NULL ) took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "TotalProgress-860C0FE1A17656448D535DDC236F7F27" ( "TotalFiles" INTEGER NOT NULL, "TotalBlocks" INTEGER NOT NULL, "TotalSize" INTEGER NOT NULL , "FilesFullyRestored" INTEGER NOT NULL, "FilesPartiallyRestored" INTEGER NOT NULL , "BlocksRestored" INTEGER NOT NULL, "SizeRestored" INTEGER NOT NULL )
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "TotalProgress-860C0FE1A17656448D535DDC236F7F27" took 0:00:00:00.002
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "TotalProgress-860C0FE1A17656448D535DDC236F7F27"
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE TEMPORARY TABLE "FileProgress-860C0FE1A17656448D535DDC236F7F27" ( "FileId" INTEGER PRIMARY KEY , "TotalBlocks" INTEGER NOT NULL, "TotalSize" INTEGER NOT NULL , "BlocksRestored" INTEGER NOT NULL, "SizeRestored" INTEGER NOT NULL ) took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "FileProgress-860C0FE1A17656448D535DDC236F7F27" ( "FileId" INTEGER PRIMARY KEY , "TotalBlocks" INTEGER NOT NULL, "TotalSize" INTEGER NOT NULL , "BlocksRestored" INTEGER NOT NULL, "SizeRestored" INTEGER NOT NULL )
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "FileProgress-860C0FE1A17656448D535DDC236F7F27" took 0:00:00:00.001
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "FileProgress-860C0FE1A17656448D535DDC236F7F27"
* Mar 15, 2019 9:33 AM: Starting - CreateProgressTracker
* Mar 15, 2019 9:33 AM: FindMissingBlocks took 0:00:00:00.002
* Mar 15, 2019 9:33 AM: Restore list contains 64 blocks with a total size of 6.09 MB
* Mar 15, 2019 9:33 AM: ExecuteScalarInt64: SELECT SUM("Size") FROM "Blocks-E223E078E1415E45B54CD4503D74991A" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteScalarInt64: SELECT SUM("Size") FROM "Blocks-E223E078E1415E45B54CD4503D74991A"
* Mar 15, 2019 9:33 AM: Starting - FindMissingBlocks
* Mar 15, 2019 9:33 AM: SetTargetPaths took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: UPDATE "Fileset-E223E078E1415E45B54CD4503D74991A" SET "TargetPath" = "C:\Users\Jay\Desktop\" || "TargetPath" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: UPDATE "Fileset-E223E078E1415E45B54CD4503D74991A" SET "TargetPath" = "C:\Users\Jay\Desktop\" || "TargetPath"
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: UPDATE "Fileset-E223E078E1415E45B54CD4503D74991A" SET "TargetPath" = SUBSTR("Path", 80) took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: UPDATE "Fileset-E223E078E1415E45B54CD4503D74991A" SET "TargetPath" = SUBSTR("Path", 80)
* Mar 15, 2019 9:33 AM: Mapping restore path prefix to "\\SERVER\Data (E)\ALEX Dist\Alex Dist from Public\Databases and contacts lists\" to "C:\Users\Jay\Desktop\"
* Mar 15, 2019 9:33 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Fileset-E223E078E1415E45B54CD4503D74991A" WHERE SUBSTR("Path", 1, 79) = "\\SERVER\Data (E)\ALEX Dist\Alex Dist from Public\Databases and contacts lists\" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Fileset-E223E078E1415E45B54CD4503D74991A" WHERE SUBSTR("Path", 1, 79) = "\\SERVER\Data (E)\ALEX Dist\Alex Dist from Public\Databases and contacts lists\"
* Mar 15, 2019 9:33 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Fileset-E223E078E1415E45B54CD4503D74991A" WHERE SUBSTR("Path", 1, 125) = "\\SERVER\Data (E)\ALEX Dist\Alex Dist from Public\Databases and contacts lists\Alex Database - Current as at Sept. '11.accdb\" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Fileset-E223E078E1415E45B54CD4503D74991A" WHERE SUBSTR("Path", 1, 125) = "\\SERVER\Data (E)\ALEX Dist\Alex Dist from Public\Databases and contacts lists\Alex Database - Current as at Sept. '11.accdb\"
* Mar 15, 2019 9:33 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Fileset-E223E078E1415E45B54CD4503D74991A" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Fileset-E223E078E1415E45B54CD4503D74991A"
* Mar 15, 2019 9:33 AM: Starting - SetTargetPaths
* Mar 15, 2019 9:33 AM: PrepareRestoreFileList took 0:00:00:00.014
* Mar 15, 2019 9:33 AM: Needs to restore 1 files (6.09 MB)
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT COUNT(DISTINCT "Fileset-E223E078E1415E45B54CD4503D74991A"."Path"), SUM("Blockset"."Length") FROM "Fileset-E223E078E1415E45B54CD4503D74991A", "Blockset" WHERE "Fileset-E223E078E1415E45B54CD4503D74991A"."BlocksetID" = "Blockset"."ID" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT COUNT(DISTINCT "Fileset-E223E078E1415E45B54CD4503D74991A"."Path"), SUM("Blockset"."Length") FROM "Fileset-E223E078E1415E45B54CD4503D74991A", "Blockset" WHERE "Fileset-E223E078E1415E45B54CD4503D74991A"."BlocksetID" = "Blockset"."ID"
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE INDEX "Blocks-E223E078E1415E45B54CD4503D74991A_FileIdIndexIndex" ON "Blocks-E223E078E1415E45B54CD4503D74991A" ("FileId", "Index") took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE INDEX "Blocks-E223E078E1415E45B54CD4503D74991A_FileIdIndexIndex" ON "Blocks-E223E078E1415E45B54CD4503D74991A" ("FileId", "Index")
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE INDEX "Blocks-E223E078E1415E45B54CD4503D74991A_HashSizeIndex" ON "Blocks-E223E078E1415E45B54CD4503D74991A" ("Hash", "Size") took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE INDEX "Blocks-E223E078E1415E45B54CD4503D74991A_HashSizeIndex" ON "Blocks-E223E078E1415E45B54CD4503D74991A" ("Hash", "Size")
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE INDEX "Fileset-E223E078E1415E45B54CD4503D74991A_Index" ON "Fileset-E223E078E1415E45B54CD4503D74991A" ("TargetPath") took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE INDEX "Fileset-E223E078E1415E45B54CD4503D74991A_Index" ON "Fileset-E223E078E1415E45B54CD4503D74991A" ("TargetPath")
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE TEMPORARY TABLE "Blocks-E223E078E1415E45B54CD4503D74991A" ("ID" INTEGER PRIMARY KEY, "FileID" INTEGER NOT NULL, "Index" INTEGER NOT NULL, "Hash" TEXT NOT NULL, "Size" INTEGER NOT NULL, "Restored" BOOLEAN NOT NULL, "Metadata" BOOLEAN NOT NULL) took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Blocks-E223E078E1415E45B54CD4503D74991A" ("ID" INTEGER PRIMARY KEY, "FileID" INTEGER NOT NULL, "Index" INTEGER NOT NULL, "Hash" TEXT NOT NULL, "Size" INTEGER NOT NULL, "Restored" BOOLEAN NOT NULL, "Metadata" BOOLEAN NOT NULL)
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: CREATE TEMPORARY TABLE "Fileset-E223E078E1415E45B54CD4503D74991A" ("ID" INTEGER PRIMARY KEY, "Path" TEXT NOT NULL, "BlocksetID" INTEGER NOT NULL, "MetadataID" INTEGER NOT NULL, "TargetPath" TEXT NULL, "DataVerified" BOOLEAN NOT NULL) took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: CREATE TEMPORARY TABLE "Fileset-E223E078E1415E45B54CD4503D74991A" ("ID" INTEGER PRIMARY KEY, "Path" TEXT NOT NULL, "BlocksetID" INTEGER NOT NULL, "MetadataID" INTEGER NOT NULL, "TargetPath" TEXT NULL, "DataVerified" BOOLEAN NOT NULL)
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "Blocks-E223E078E1415E45B54CD4503D74991A" took 0:00:00:00.001
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Blocks-E223E078E1415E45B54CD4503D74991A"
* Mar 15, 2019 9:33 AM: ExecuteNonQuery: DROP TABLE IF EXISTS "Fileset-E223E078E1415E45B54CD4503D74991A" took 0:00:00:00.001
* Mar 15, 2019 9:33 AM: Starting - ExecuteNonQuery: DROP TABLE IF EXISTS "Fileset-E223E078E1415E45B54CD4503D74991A"
* Mar 15, 2019 9:33 AM: Searching backup 16 (6/02/2019 8:00:00 p.m.) ...
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
* Mar 15, 2019 9:33 AM: ExecuteScalarInt64: SELECT "Timestamp" FROM "Fileset" WHERE "ID" = 39 took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteScalarInt64: SELECT "Timestamp" FROM "Fileset" WHERE "ID" = 39
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT "ID" FROM "Fileset" WHERE "Timestamp" <= 1549483200 ORDER BY "Timestamp" DESC took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT "ID" FROM "Fileset" WHERE "Timestamp" <= 1549483200 ORDER BY "Timestamp" DESC
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC took 0:00:00:00.001
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT "ID", "Timestamp" FROM "Fileset" ORDER BY "Timestamp" DESC
* Mar 15, 2019 9:33 AM: Starting - PrepareRestoreFileList
* Mar 15, 2019 9:33 AM: Starting - PrepareBlockList
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT DISTINCT "Name", "State" FROM "Remotevolume" WHERE "Name" IN (SELECT "Name" FROM "Remotevolume" WHERE "State" IN ("Deleted", "Deleting")) AND NOT "State" IN ("Deleted", "Deleting") took 0:00:00:00.001
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT DISTINCT "Name", "State" FROM "Remotevolume" WHERE "Name" IN (SELECT "Name" FROM "Remotevolume" WHERE "State" IN ("Deleted", "Deleting")) AND NOT "State" IN ("Deleted", "Deleting")
* Mar 15, 2019 9:33 AM: RemoteOperationList took 0:00:00:02.639
* Mar 15, 2019 9:33 AM: Backend event: List - Completed: (43 bytes)
* Mar 15, 2019 9:33 AM: Backend event: List - Started: ()
* Mar 15, 2019 9:33 AM: Starting - RemoteOperationList
* Mar 15, 2019 9:33 AM: ExecuteScalarInt64: SELECT COUNT(*) FROM "Block" WHERE "Size" > 102400 took 0:00:00:00.003
* Mar 15, 2019 9:33 AM: Starting - ExecuteScalarInt64: SELECT COUNT(*) FROM "Block" WHERE "Size" > 102400
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT "Key", "Value" FROM "Configuration" took 0:00:00:00.000
* Mar 15, 2019 9:33 AM: Starting - ExecuteReader: SELECT "Key", "Value" FROM "Configuration"
* Mar 15, 2019 9:33 AM: ExecuteReader: SELECT "Key", "Value" FROM "Configuration" took 0:00:00:00.001
Also tried a database repair before that, (again), but it said it’s all good