What are the challenges you face when working across database platforms? Take the survey
Options

Determine the Backup Folder in TransactSQL

jimclarkjimclark Posts: 4
edited August 4, 2011 2:19AM in SQL Backup Previous Versions
Can I retrieve the SQL Backup backup folder using TransactSQL with the SQBUtility or in some other way?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.