How can we help you today? How can we help you today?

How can I set backup options via t-sql commands

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.
jim.wilson
0

Comments

3 comments

Sort by
  • James Moore
    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
    0
  • jim.wilson
    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.
    jim.wilson
    0
  • qcjims
    James Moore wrote:
    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
    qcjims
    0

Add comment

Please sign in to leave a comment.