WSUS Downstream server not synchronising with upstream server

[tike100]

I'm having some problems with downstream servers syncing with the upstream server.

 

All WSUS Servers are WSUS Server Version: 3.2.7600.256 and I have installed KB2720211 and KB2734608.

 

The Database is held in the Windows Internal Database

 

The Upstream server is synchronising with Windows Update absolutely fine, and downloading updates OK.

 

The three downstream servers however are not. They are reporting as failed with the below message =

 

Result = An error occurred with the server’s data store.

 

Clicking Details shows the below detailed message =

 

SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.SqlClient.SqlDataReader.Read()
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ReadOneRow()
at Microsoft.UpdateServices.Internal.DataAccess.HideUpdatesForReplicaSync(String xmlUpdateIds)
at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ProcessHiddenUpdates(Guid[] hiddenUpdates)
at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ReplicaSync()
at Microsoft.UpdateServic

 

Whats also weird is the computer status is being sync’d to the upstream server and the downstream servers are downloading new updates, yet the sync is still failing?

Can anyone shed some light?

 

The upstream server = Server 2003

1 Downstream server = Server 2008 R2

2 Downstream Servers = Server 2003

[jifflemon]

How big is the database on the upstream server? Typically see that error when the upstream database is too large.

 

Don't rely on the wizard to do any proper maintenance, You'll need a scripted solution as well as some manual work to reduce the size.