[JWT] How to Windows Server Update Services (WSUS) WID Database recovery?

[JWT] How to Windows Server Update Services (WSUS) WID Database recovery?

  
Forge Component
(3)
Published on 10 Oct (6 days ago) by João Almeida
3 votes
Published on 10 Oct (6 days ago) by João Almeida

I am working as a SQL Server DBA Developer. I am facing a crazy problem.  My WSUS server, a Hyper-V VM running on a Window Server 2012 R2 Host, after a host power failure and later boot-up, showing error:

Application: 3414
Source: MSSQL$MICROSOFT##WID
An error occurred during recovery, preventing the database 'SUSDB' (5:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

Application: 3313
Source: MSSQL$MICROSOFT##WID
During redoing of a logged operation in database 'SUSDB', an error occurred at log record ID (1212707:3000:2). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.

Application: 3456
Source: MSSQL$MICROSOFT##WID
Could not redo log record (1212707:3000:2), for transaction ID (0:0), on page (1:635), allocation unit 281474979397632, database 'SUSDB' (database ID 5). Page: LSN = (1212704:2144:2), allocation unit = 281474979397632, type = 1. Log: OpCode = 4, context 18, PrevPageLSN: (1212705:11360:1). Restore from a backup of the database, or repair the database.

I conclude WID SUSDB database got corrupted and unfortunately, I don't have Windows Server Update Services or Database backup. How can I repair the database since no SQL server management components are installed?


Thanks & Regards
Camillelola

Hi Camille,


This sounds bad. Probably without backup you will have a lot of issues to fix. 

I suggest you post your question in a SQL Server forum.  This forum is about Outsystems platform and other stuffs related to it. There you will have more experts in this subject to help you.


Best Regards

Fabio Fantato



Hi Fabio Fantato,


Okay I will try, Thanks for your reply


Best Regards
Camillelola