Determine the Backup Folder in TransactSQL

jimclark · August 3, 2011 2:33PM

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

petey · August 4, 2011 2:19AM

To get the default SQL Backup backup folder:

DECLARE @value NVARCHAR&#40;128&#41;
EXEC master..sqbutility 1014, 'BackupFolder', @value OUT
SELECT @value

To get the default SQL Server backup folder:

DECLARE @value NVARCHAR&#40;128&#41;
EXEC master..sqbutility 1013, @value OUT
SELECT @value

Comments