Thursday, August 16, 2012

Fix WSUS Internal DB if corrupted


sqlcmd -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

ALTER DATABASE SUSDB SET SINGLE_USER WITH NO_WAIT

DBCC CHECKDB

go

If the about command cannot fix, try this one but will have data loss
DBCC checkdb ('SUSDB', repair_allow_data_loss)


Finally,
ALTER DATABASE SUSDB SET MULTI_USER WITH NO_WAIT
go

3 comments: