Post reply

change the default backup directory?

  • August 5, 2004 at 9:27 am

    #85943

    Hi All,

    When you create a backup job through the 'Database Maintenance Plan Wizard' there are two options on where to store the .BAK files:

    1)use the defualt backup directory

    2)use a directory that you specify

    Is there a way to change the default backup directory in the first option to use a different path?

    I'd appreciate any feedback!

    Thanks,

    John

     

  • August 5, 2004 at 9:38 am

    #517865

    Registry setting HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSERVER\MSSQLServer\BackupDirectory

    I've got a great big list of what all these registry settings do somewhere and I plan to write them up as an article.  It's just one of those things that are on my list of things to do.

     

    LinkedIn Profile

  • August 5, 2004 at 12:34 pm

    #517895

    Worked like a charm - I'd definitely be interested in seeing an article published w/ all those reg settings!

    Thanks!

    John

     

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

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