Appendix I: Database Maintenance
In order to keep your WSUS server functioning correctly, you should have a maintenance plan that includes re-indexing the database on a regular basis, preferably at least once a month.
If you are using Base de données interne Windows, you will need to use the sqlcmd utility. For more information about the sqlcmd utility, see sqlcmd Utility (http://go.microsoft.com/fwlink/?LinkId=81183).
To use this script with Base de données interne Windows, you should run the following command:
sqlcmd -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query –i <scriptLocation>\WsusDBMaintenance.sql
where <scriptLocation> is the directory where you have copied the WsusDBMaintenance script.