Determine the Backup Folder in TransactSQL

jimclark

Can I retrieve the SQL Backup backup folder using TransactSQL with the SQBUtility or in some other way?

petey

To get the default SQL Backup backup folder:

DECLARE @value NVARCHAR(128)
EXEC master..sqbutility 1014, 'BackupFolder', @value OUT
SELECT @value

To get the default SQL Server backup folder:

DECLARE @value NVARCHAR(128)
EXEC master..sqbutility 1013, @value OUT
SELECT @value