How can I set backup options via t-sql commands

jim.wilsonjim.wilson Posts: 8
edited September 22, 2009 12:02AM in SQL Backup Previous Versions
I would like to set some Server Options related to SQL Backup log files via t-sql. Can this be done, and if so how? We have over 100 instances of SQL with Redgate installed, and I would rather not have to log into the UI on all of them to make this change. Is there some way the extended sproc sqbutility can be used to do this? Thanks.

Comments

  • Hi Jim,

    This is possible - Please pm me the settings you want to set then we can come up with the right TSQL for you.

    Regards,

    James
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
  • I would like to programmatically set the log file folder retention to "delete log files" older than 7 days. This feature is disabled by default and I would like to enable it and set it to 7 days as part of our nightly maint process.
  • Hi Jim,

    This is possible - Please pm me the settings you want to set then we can come up with the right TSQL for you.

    James

    Please post how this is done in the forums. We have 100 physical systems (150+ instances) and would like to be able to do this as well.


    -js
Sign In or Register to comment.