Accedi
 
HomeLibraryRisorseFormazioneDownloadSupportoCommunityForumBlog
Risorse per professionisti IT >
> 
> 
WSUS maintenance script as part of a SQL maintenance plan

Answered WSUS maintenance script as part of a SQL maintenance plan

  • giovedì 6 dicembre 2012 03:48
     
     
    Registrati per votare
    0

    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.

     

Tutte le risposte

  • giovedì 6 dicembre 2012 13:51
    Moderatore
     
     Con risposta
    Registrati per votare
    0

    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.

     
  • giovedì 6 dicembre 2012 14:57
     
     
    Registrati per votare
    0
    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?
     
  • giovedì 6 dicembre 2012 15:28
    Moderatore
     
     Con risposta
    Registrati per votare
    0
    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.