Backup manager "invalid path" on Linux SQL Server
0 vote
Hi
I have tried to setup backup of my DVLS DB, but DVLS doesn't seam to like when the path uses forward slash.
This is the "correct" path to where my backup should reside, but DVLS gives me a "Invalid path":
SQL 2022 on Linux Docker.
DVLS version: 2022.2.6.0
Regards Lars
Remote Desktop Manager connected with Devolutions Server running newest versions.
------------------------Signature------------------------
Sorry if any of above sounds harsh or provoking, it is NOT meant as such, but I have Asperger's and don't always know.
My intentions is always to be friendly.
-------------------------------------------------------------
All Comments (4)
Hi,
The database backup is saved on DVLS server itself. And DVLS is installed on a Windows machine. This is why you got an "Invalid database backup path" message. The path is not a valid Windows path. If I understand correctly, you would like to save your database backup on a separate server ?
Best regards,
François Dubois
Hi
As discussed in another thread, SQL server can only take a backup local to it self, so I have to specify a "local" path for the SQL server to backup to.
And my SQL is running in a Linux docker, where /sqldata/backup is a path local to the SQL server.
Regards Lars
Remote Desktop Manager connected with Devolutions Server running newest versions.
------------------------Signature------------------------
Sorry if any of above sounds harsh or provoking, it is NOT meant as such, but I have Asperger's and don't always know.
My intentions is always to be friendly.
-------------------------------------------------------------
Hi,
I have created a ticket in our system to investigate that. We will let you know when it will be fixed.
Best regards,
François Dubois
Hello M.Lars,
You can use the dvls built-in backup tool with a SQL server inside a container starting from the next beta onward. However, due to the fact that the DVLS scheduler is not installed where the SQL server is the feature that zips and secure the file with a password will not work. Also, DVLS cannot guarantee that the file was successfully created. Despite this, after testing on our side we had no instance of failure during the backup process. Thank you for your patience.
Best regards,
Docker image used: http://mcr.microsoft.com/mssql/server:2022-latest
Zacharia Ellaham