ktaranov/sqlserver-kit

Find more tools and utilities

ktaranov opened this issue · 3 comments

Grate job with Get_SQL_Server_Backup_Directory.sql, but doesnt work in linux version, any idea of how to get the default back up directory, like we get:
Select SERVERPROPERTY('INSTANCEDEFAULTDATAPATH')],
SERVERPROPERTY('INSTANCEDEFAULTLOGPATH');

Thanks !!

Hi, @Walcar . Could you provide full output for your instance: SELECT @@VERSION;

Hi, @ktaranov.
This is the result of Select @@Version:

Microsoft SQL Server 2017 (RTM-CU7) (KB4229789) - 14.0.3026.27 (X64) May 10 2018 12:38:11 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 16.04.4 LTS)