윈도우 2012 WSUS 용량 정리 시 문제(데이터베이스 에러, time out)

데이터베이스 에러가 뜰 때,

아래 방법으로 진행 시, 중간에 에러가 뜨고 조치가 안 됨(2012 기준)

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/dd939795(v=ws.10)

또 다른 방법

https://social.technet.microsoft.com/Forums/ie/en-US/7b12f8b2-d0e6-4f63-a98a-019356183c29/getting-past-wsus-cleanup-wizard-time-out-removing-unnecessary-updates?forum=winserverwsus

1. Enable "piped pipes" access for the Microsoft##SSEE database. Access wasn't enabled on mine initially.

2. Open management studio and enter "\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query" under server name.

3. Click "options" and select "Named Pipes" under "Network protocol" under the "Connection Properties" tab

4. Click "connect"

5. Execute a query for:

USE SUSDB
GO
exec spGetObsoleteUpdatesToCleanup

You will see a list of obsolete updates pop up. Copy these to a txt file.

6. Execute "exec spDeleteUpdate @localUpdateID=000000" where 000000=UpdateID

Edit: I wasn't using or maintaining WSUS so there were nearly 20,000 obsolete updates!