• James Lean (2/23/2011)


    You CAN change the default backup directory using SSMS very easily:-

    - From Object Explorer, right-click on the server and choose Facets.

    - In the Facet dropdown, choose Server Settings.

    - Change the BackupDirectory to your chosen folder.

    No server restart is necessary. You can verify the change by checking the registry key.

    Oh dear. I had no idea about that. I'd always used the registry in the past as that was the only way I could find to do it, and BOL seemed to back me up.

    I'm not sure if anything can be done to fix the question, but in the meantime I can only apologise for the incorrect answer and explanation.

    Duncan