• 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.

    Thanks - That is very good information.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events