How can I set backup options via t-sql commands

jim.wilson

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.

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

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.

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