Post reply

how to determine default backup directory?

  • November 25, 2003 at 1:03 pm

    #106489

    How do I determine default backup directory for instance of SQL Server?

    According to BOL, "'default directory' is set during installation and stored in the BackupDirectory registry key under KEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer."

    How do I obtain this value from the registry?

    Thanks in advance

    Billy

  • November 25, 2003 at 1:21 pm

    #483611 

    EXEC master..xp_regread 'HKEY_LOCAL_MACHINE','Software\Microsoft\MSSQLServer\MSSQLServer','Backupdirectory'

    --Jonathan



    --Jonathan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply