novumprs
asked on
How Do I Recover Corrupt WSUS DataStore.edb
A bad UPS killed my WSUS installation and I had to reinstall WSUS, including MSDE, to get it running again. It's working fine now, except I am continually getting the following errors in the machine's application log:
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------
Event Type: Error
Event Source: ESENT
Event Category: Logging/Recovery
Event ID: 452
Date: 4/10/2007
Time: 4:42:46 PM
User: N/A
Computer: WHIRLWIND
Description:
wuaueng.dll (1668) SUS20ClientDataStore: Database C:\WINDOWS\SoftwareDistrib ution\Data Store\Data Store.edb requires logfiles 13-15 in order to recover successfully. Recovery could only locate logfiles starting at 15.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------
followed by
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------
Event Type: Error
Event Source: ESENT
Event Category: Logging/Recovery
Event ID: 454
Date: 4/10/2007
Time: 4:42:46 PM
User: N/A
Computer: WHIRLWIND
Description:
wuaueng.dll (1668) SUS20ClientDataStore: Database recovery/restore failed with unexpected error -543.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------
The event pair occurs every 30 minutes. The database in question, DataStore.edb, has not been modified since the problems with the UPS led to its corruption. The log files it wants are no where to be found, so I'm at a loss how to resolve this. The files in the log directory are as follows:
03/18/2007 11:28 AM 8,192 edb.chk
04/10/2007 04:42 PM 131,072 edb.log
03/18/2007 11:28 AM 131,072 edb0000D.log
03/18/2007 11:28 AM 131,072 edb0000E.log
03/18/2007 10:29 AM 131,072 res1.log
03/18/2007 10:29 AM 131,072 res2.log
--------------------------
Event Type: Error
Event Source: ESENT
Event Category: Logging/Recovery
Event ID: 452
Date: 4/10/2007
Time: 4:42:46 PM
User: N/A
Computer: WHIRLWIND
Description:
wuaueng.dll (1668) SUS20ClientDataStore: Database C:\WINDOWS\SoftwareDistrib
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
--------------------------
followed by
--------------------------
Event Type: Error
Event Source: ESENT
Event Category: Logging/Recovery
Event ID: 454
Date: 4/10/2007
Time: 4:42:46 PM
User: N/A
Computer: WHIRLWIND
Description:
wuaueng.dll (1668) SUS20ClientDataStore: Database recovery/restore failed with unexpected error -543.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
--------------------------
The event pair occurs every 30 minutes. The database in question, DataStore.edb, has not been modified since the problems with the UPS led to its corruption. The log files it wants are no where to be found, so I'm at a loss how to resolve this. The files in the log directory are as follows:
03/18/2007 11:28 AM 8,192 edb.chk
04/10/2007 04:42 PM 131,072 edb.log
03/18/2007 11:28 AM 131,072 edb0000D.log
03/18/2007 11:28 AM 131,072 edb0000E.log
03/18/2007 10:29 AM 131,072 res1.log
03/18/2007 10:29 AM 131,072 res2.log
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks. Re-posting with corrected service names:
WSUS itself is probably fine since it stores its data in SQL, not an ESENT db, the Automatic Updates service on that box is however, hosed. Here's how to fix automatic updates.
NET Stop WUAUSERV
NET Stop BITS
Rename C:\Windows\SoftwareDistrib ution to C:\Windows\SoftwareDistrib ution.old
NET Start WUAUSERV
Goto Windows Update and download available updates.
WSUS itself is probably fine since it stores its data in SQL, not an ESENT db, the Automatic Updates service on that box is however, hosed. Here's how to fix automatic updates.
NET Stop WUAUSERV
NET Stop BITS
Rename C:\Windows\SoftwareDistrib
NET Start WUAUSERV
Goto Windows Update and download available updates.
ASKER
One minor note: on my W2K3 server, the update service is WUAUSERV vice wuausvc.