question

MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 asked ErlandSommarskog commented

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

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-generalsql-server-migrationsql-server-migration-assistant
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MJJakati-2429

Our forum is mainly focused on the general issue of Teams for Linux troubleshooting. According to your description, your issue is not in our support scope. So I will remove team-linux tag. Thanks for your understanding!

0 Votes 0 ·
MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 answered ErlandSommarskog commented

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What version of SSMS do you see under Help->About?

0 Votes 0 ·
MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 answered

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>

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 answered MJJakati-2429 edited

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

https://docs.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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Somethings seems to me messed up on your system, but I can say what. I will ask some questions, but I am not sure that they will lead anywhere.

The folder dialog above, where exactly did you get this one?

Can you post a screen of what you have under Database default locations? (Right-click server in Object Explorer, select Properties and then Database Settings.)

What does SELECT * FROM sys.dm_os_enumerate_fixed_drives return?

What does SELECT serverproperty('Pathseparator') returm?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 answered ErlandSommarskog commented

Hello ErlandSommarskog,

Below is the information which you requested.

99527-sql-c-drive-on-linux.png

SELECT * FROM sys.dm_os_enumerate_fixed_drives
/ 3 DRIVE_FIXED 77457788928

SELECT serverproperty('Pathseparator')
/





· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That all seems pretty normal to me. Although, you did not say exactly when you encountered this dialog that tops with C: And for matter, it could help a screenshot where you get the error message in the title. Maybe I have been looking in the wrong place?

0 Votes 0 ·
MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 answered

I got this error when I am trying to view the logs files of SQL server jobs

Below is the screen shot.

101154-c-drive-comming-in-output-log-file-view.png



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

I've tried this, and I was able to reproduce the error. I also compared to how it works on Windows, and found that it does not really work that much better. If I run SSMS on the machine where SQL Server is running, I can access the file. But if I run SSMS from a different machine, I get:

Access to the path '\\PRESENT10\C$\Program Files\Microsoft SQL Server\MSSQL15.NITTON\MSSQL\Log\Blafs.log' is denied.

That is, SSMS tries to access the file directly, without going through SQL Server. This would work for Windows if I enable administrative shares on PRESENT10 (which is not really recommended)

True, what it tries with the Linux machine has absolutely no chance of working.

I would suggest that you file a bug on https://feedback.azure.com/forums/908035-sql-server. (You could first make an attempt to see if this has already been failed, but the search capabilities are not that fantastic.)

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MJJakati-2429 avatar image
0 Votes"
MJJakati-2429 answered ErlandSommarskog commented

Thanks for looking into this, I have raised a bug request from your provided link.

https://feedback.azure.com/forums/908035-sql-server/suggestions/43542324-this-is-a-bug-which-i-came-across-in-sql-server-on

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.