I’m making regular backups with SQLBackupAndFTP from my SQL Server 2017 Server.
Backups are working good, but I cannot restore any backups both directly from the backup process and from a new Restore task.
In both ways I’m receiving the same error:
11/3/2022 4:53 PM Failed to restore "test01_db_TestRestore" database. Could not find a part of the path 'L:\Microsoft SQL Server\Transaction Logs'.`
This is the full log of the restore job:
11/3/2022 4:52 PM Connecting to "SQL Server": "sql1.dev.my.domain.com".
11/3/2022 4:52 PM Connected to "SQL RTM Web Edition (64-bit)".
11/3/2022 4:52 PM Connecting to "Folder" destination "\\backup\mssql-backups\sqldev1\test01_db".
11/3/2022 4:52 PM Searching files by mask "test01_db*.*".
11/3/2022 4:52 PM Found "1599" files.
11/3/2022 4:52 PM Getting "test01_db202210281548.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202210281548.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\10_28_2022 3_48_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\10_28_2022 3_48_00 PM\test01_db202210281548.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031213diff.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031213diff.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 12_13_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 12_13_00 PM\test01_db202211031213diff.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031230log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031230log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 12_30_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 12_30_00 PM\test01_db202211031230log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031245log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031245log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 12_45_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 12_45_00 PM\test01_db202211031245log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031300log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031300log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_00_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_00_00 PM\test01_db202211031300log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031315log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031315log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_15_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_15_00 PM\test01_db202211031315log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031330log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031330log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_30_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_30_00 PM\test01_db202211031330log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031345log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031345log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_45_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 1_45_00 PM\test01_db202211031345log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031400log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031400log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_00_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_00_00 PM\test01_db202211031400log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031415log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031415log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_15_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_15_00 PM\test01_db202211031415log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031430log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031430log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_30_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_30_00 PM\test01_db202211031430log.7z" file with 7zip archiver.
11/3/2022 4:52 PM Getting "test01_db202211031445log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:52 PM Downloading file "test01_db202211031445log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_45_00 PM".
11/3/2022 4:52 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 2_45_00 PM\test01_db202211031445log.7z" file with 7zip archiver.
11/3/2022 4:53 PM Getting "test01_db202211031500log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:53 PM Downloading file "test01_db202211031500log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_00_00 PM".
11/3/2022 4:53 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_00_00 PM\test01_db202211031500log.7z" file with 7zip archiver.
11/3/2022 4:53 PM Getting "test01_db202211031515log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:53 PM Downloading file "test01_db202211031515log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_15_00 PM".
11/3/2022 4:53 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_15_00 PM\test01_db202211031515log.7z" file with 7zip archiver.
11/3/2022 4:53 PM Getting "test01_db202211031530log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:53 PM Downloading file "test01_db202211031530log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_30_00 PM".
11/3/2022 4:53 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_30_00 PM\test01_db202211031530log.7z" file with 7zip archiver.
11/3/2022 4:53 PM Getting "test01_db202211031545log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:53 PM Downloading file "test01_db202211031545log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_45_00 PM".
11/3/2022 4:53 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 3_45_00 PM\test01_db202211031545log.7z" file with 7zip archiver.
11/3/2022 4:53 PM Getting "test01_db202211031600log.7z" file metadata on "\\backup\mssql-backups\sqldev1\test01_db" folder.
11/3/2022 4:53 PM Downloading file "test01_db202211031600log.7z" to "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 4_00_00 PM".
11/3/2022 4:53 PM Uncompressing "\\backup.my.domain.com\mssql-backups\SQLBackupAndFtp_Temp\Pranas.NET\SBF\backup\4f347481d0df47d085321126d221c18a\test01_db\11_3_2022 4_00_00 PM\test01_db202211031600log.7z" file with 7zip archiver.
11/3/2022 4:53 PM Restoring "test01_db_TestRestore" database from files: "test01_db202210281548.bak, test01_db202211031213diff.bak, test01_db202211031230log.bak, test01_db202211031245log.bak, test01_db202211031300log.bak, test01_db202211031315log.bak, test01_db202211031330log.bak, test01_db202211031345log.bak, test01_db202211031400log.bak, test01_db202211031415log.bak, test01_db202211031430log.bak, test01_db202211031445log.bak, test01_db202211031500log.bak, test01_db202211031515log.bak, test01_db202211031530log.bak, test01_db202211031545log.bak, test01_db202211031600log.bak".
11/3/2022 4:53 PM Failed to restore "test01_db_TestRestore" database. Could not find a part of the path 'L:\Microsoft SQL Server\Transaction Logs'.
11/3/2022 4:53 PM Disconnecting from "Folder" destination "\\backup\mssql-backups\sqldev1\test01_db".
11/3/2022 4:53 PM Deleting temporary files.
11/3/2022 4:53 PM Job "Restore Job - 3" finished with "1" errors.
11/3/2022 4:53 PM Sending report to ${https://sqlbackupandftp.com/weblog?jobid=<my_job_id>|Web Log}.
Could you help me to understand where I’m wrong, please?
Thank you very much!