Exportar (0) Imprimir
Expandir Tudo

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 (http://go.microsoft.com/fwlink/?LinkId=87027) allows you to re-index any version of the WSUS database, either SQL Server or Windows Internal Database.

If you are using Windows Internal Database, 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 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.

Isso foi útil para você?
(1500 caracteres restantes)
Agradecemos os seus comentários

Contribuições da comunidade

ADICIONAR
A Microsoft está realizando uma pesquisa online para saber sua opinião sobre o site do MSDN. Se você optar por participar, a pesquisa online lhe será apresentada quando você sair do site do MSDN.

Deseja participar?
Mostrar:
© 2015 Microsoft