1. Usually, we want atomic all-or-nothing operations in databases, so when the expiry times out the database helpfully rolls back expired updates, leaving us in the position we started. In addition to having too many updates it appears that certain obsolete updates have a large number of revisions, which also slows the clearout process down.
2. The WSUS Server Cleanup utility: Removing unused and obsolete updates from the database helps keeping the overall size of the catalog down to a minimum. New clients will have to download the catalog (and also clients falling over from one Software Update Point to another), and size matters when dealing with slow WAN links and thousands of.

Remove declined updates from the WSUS Database. Clean out all the synchronization logs that have built up over time (configurable, with the default keeping the last 14 days of logs). Compress Update Revisions. Remove Obsolete Updates. May 12, 2016 Hello to everyone: from a couple of weeks I have had unforeseen difficulties on a domain computer that signals 'Databases are out of date.' The situation occurs in the group of computers that I follow to the console (186 clients). D data definition language. Data dictionary. Metadata that keeps track of database objects such as tables, indexes, and table columns.For the MySQL data dictionary, introduced in MySQL 8.0, metadata is physically located in InnoDB file-per-table tablespace files in the mysql database directory. For the InnoDB data dictionary, metadata is physically located in the InnoDB system.

Databases Obsolete But Update Fails At 78% Start

If you run a Windows Server Update Services (WSUS) server, you know that sometimes it can develop problems. Specifically the WSUS database can need a manual clean up. There are several scripts around that handle this but I found one HERE that helped me quite a bit.

Databases Obsolete But Update Fails At 78% Game

Note that this script does not replace the WSUS SERVER CLEAN UP WIZARD. If you are having problems with that (like SERVER NODE RESET messages), click HERE for the fix.

To run this script:

Data Bases Obsolete But Update Fails At 78%25

1. Download it directly from us HERE and unzip the contents
   .
2. Start a PowerShell as an Admin
   .
3. If you are running WSUS from a Windows Internal Database on Server 2012 enter the following command:
   .
   sqlcmd -I -S .pipeMICROSOFT##WIDtsqlquery -i C:WsusDBMaintenance.sql
   .
   If you are running WSUS from a from a Windows Internal Database on Server 2008 or SBS 2011, enter the following command:
   .
   sqlcmd.exe -I -S np:.pipeMSSQL$MICROSOFT##SSEEsqlquery -i C:WSUSDBMaintenance.sql
   .updated Jul 18 2018
   (Be sure adjust the path of C:WsusDBMaintenance.sql to reflect where you actually put the script)
   .
4. Wait.

I have not had this take more than 15 minutes but I have read reports of it taking a VERY long time.

Databases Obsolete But Update Fails At 78% End

I found THIS post and THIS post helpful when dealing with the WSUS problem.