Sunday, September 25, 2011

WSUS Maintenance: failed synchronization

You may have received error from wsyncmgr.log stating " Sync failed: LocalDBOtherError: SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.~~at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e). Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WSyncAction.WSyncAction"
You can Resolve the issue in following ways
- ReIndex the WSUS 3.0atabase
http://gallery.technet.microsoft.com/ScriptCenter/en-us/6f8cde49-5c52-4abd-9820-f1d270ddea61
-Run WSUS Cleanup wizard
Run the WSUS Server Clean-up Wizard from the bottom of the WSUS hierarchy to the top and NEVER from the top down.
Run the WSUS Server Clean-Up Wizard throughout the hierarchy on a monthly basis.
http://gallery.technet.microsoft.com/ScriptCenter/en-us/fd39c7d4-05bb-4c2d-8a99-f92ca8d08218
------------------OR--------------------
-Open WSUS administration console, select Options, and then Server Cleanup Wizard
-This wizard will remove unneeded content and computers that have not contacted the server for 30 days(Default) or more. Select all possible options, and then click Next.
- It will begin the cleanup process, and will present a summary of its work when it is finished. Click Finish to complete the process

No comments: