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.

The WsusDBMaintenance script (https://go.microsoft.com/fwlink/?LinkId=87027) allows you to re-index any version of the WSUS database, either SQL Server or Windows 내부 데이터베이스.

If you are using Windows 내부 데이터베이스, you will need to use the sqlcmd utility. For more information about the sqlcmd utility, see sqlcmd Utility (https://go.microsoft.com/fwlink/?LinkId=81183).

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.