Appendix I: Database Maintenance
Applies To: Windows Server 2003 with SP2, Windows Server Update Services
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 Windows Internal Database, you will need to use the sqlcmd utility, which can be downloaded from Feature Pack for Microsoft SQL Server 2005 (https://go.microsoft.com/fwlink/?LinkId=70728). For more information about the sqlcmd utility, see sqlcmd Utility (https://go.microsoft.com/fwlink/?LinkId=81183).
To use this script with Windows Internal Database, 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.