none
WSUS maintenance script as part of a SQL maintenance plan

    질문

  • Hi,

    Is it Ok to run the WSUS 3 maintenance script as part of a SQL maintenance plan so this process is automated? In addition to running the WSUS Cleanup Wizard I try to run this script at least once a week on all my WSUS servers. I would assume its Ok to incorporate this script, but wanted to double check. Thanks.

    2012년 12월 6일 목요일 오전 3:48

답변

  • Is it Ok to run the WSUS 3 maintenance script as part of a SQL maintenance plan so this process is automated?

    Absolutely!
    In addition to running the WSUS Cleanup Wizard I try to run this script at least once a week on all my WSUS servers.
    Both of them will be fine if run monthly; depending on the duty load of your WSUS server, you might even find that running the maintenance script only quarterly will be sufficient.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Distribution (2005-2012)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    2012년 12월 6일 목요일 오후 1:51
    중재자
  • Is there any SQL script out there that could also automate the running of the WSUS Cleanup Wizard? What about setting it as a system task on the respective servers?
    There is a PowerShell script available on codeplex that can be scheduled from Task Scheduler.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Distribution (2005-2012)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    2012년 12월 6일 목요일 오후 3:28
    중재자

모든 응답

  • Is it Ok to run the WSUS 3 maintenance script as part of a SQL maintenance plan so this process is automated?

    Absolutely!
    In addition to running the WSUS Cleanup Wizard I try to run this script at least once a week on all my WSUS servers.
    Both of them will be fine if run monthly; depending on the duty load of your WSUS server, you might even find that running the maintenance script only quarterly will be sufficient.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Distribution (2005-2012)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    2012년 12월 6일 목요일 오후 1:51
    중재자
  • Is there any SQL script out there that could also automate the running of the WSUS Cleanup Wizard? What about setting it as a system task on the respective servers?
    2012년 12월 6일 목요일 오후 2:57
  • Is there any SQL script out there that could also automate the running of the WSUS Cleanup Wizard? What about setting it as a system task on the respective servers?
    There is a PowerShell script available on codeplex that can be scheduled from Task Scheduler.

    Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
    SolarWinds Head Geek
    Microsoft MVP - Software Distribution (2005-2012)
    My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
    The views expressed on this post are mine and do not necessarily reflect the views of SolarWinds.

    2012년 12월 6일 목요일 오후 3:28
    중재자