Could not find a part of the path 'C:\var\opt\mssql\Log\backuplog.txt' in SQL server on linux

MJ Jakati 116 Reputation points
2021-05-21T16:37:49.033+00:00

Hello Team,

I have installed SQL Sever on Linux and changed the log and data files locations as well. When I ran backup job and to view the backup job output file with SSMS when I click on view I am getting below error.

Could not find a part of the path 'C:\var\opt\mssql\Log\backuplog.txt' in SQL server on linux

I am not sure some how its picking windows location format can some one help me on this. Please.

Is there any way root directly is pointing to C:\ drive?

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
SQL Server | Other
{count} votes

Accepted answer
  1. MJ Jakati 116 Reputation points
    2021-05-21T18:51:34.133+00:00

    98761-sql-root-directory-wrong.png

    Its a Linux server some how root directory is picking C:\ drive instead of /.

    Can some one please let me know how to fix it.


9 additional answers

Sort by: Most helpful
  1. MJ Jakati 116 Reputation points
    2021-05-22T04:39:29.497+00:00

    Below is the information. I did look all the SQL sever on linux its all pointing to C:\ only :(

    SQL Server Management Studio 15.0.18338.0
    SQL Server Management Objects (SMO) 16.100.41011.9
    Microsoft Analysis Services Client Tools 15.0.19205.0
    Microsoft Data Access Components (MDAC) 10.0.19041.1
    Microsoft MSXML 3.0 6.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.19042

    0 comments No comments

  2. Erland Sommarskog 121.8K Reputation points MVP Volunteer Moderator
    2021-05-22T10:17:30.757+00:00

    That is not the most recent version of SSMS, but nor is it antique, so I would not expect that to be the problem. Nevertheless, you may want to install 18.9.1 to be sure.

    I tried connecting to one my of Linux VMs, and the browsing dialog had had a / on the top. So I don't know what may have happened in your case.

    What Linux do you have? What does "SELECT @@version" report?

    0 comments No comments

  3. MJ Jakati 116 Reputation points
    2021-05-22T15:31:29.94+00:00

    Below is the version information.

    Microsoft SQL Server 2019 (RTM-CU9) (KB5000642) - 15.0.4102.2 (X64) Jan 25 2021 20:16:12 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Linux (Red Hat Enterprise Linux 8.3 (Ootpa)) <X64>

    0 comments No comments

  4. MJ Jakati 116 Reputation points
    2021-05-22T16:04:02.423+00:00

    I did install the latest version from Microsoft link but its still the same issue.

    https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

    SQL Server Management Studio 15.0.18384.0
    SQL Server Management Objects (SMO) 16.100.46367.54
    Microsoft Analysis Services Client Tools 15.0.19535.0
    Microsoft Data Access Components (MDAC) 10.0.19041.1
    Microsoft MSXML 3.0 6.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 10.0.19042

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.