problem with clean up

• Mittwoch, 13. Februar 2013 11:43

   

   
  

  0

  hi all

  i have two wsus servers.

  upstream: windows server 2008 (with SP2) + Microsoft SQL Server Enterprise Edition 2005 (9.00.5069.00)

  downstream: windows server 2008 R2 (with SP1) + MS SQL (Windows Internal Database)

  i use power shell script like this on both servers:

  [String]$updateServer = "localhost"
  [Boolean]$useSecureConnection = $False
  [Int32]$portNumber = 80
  [Boolean]$supersededUpdates = $True
  [Boolean]$expiredUpdates = $True
  [Boolean]$obsoleteUpdates = $True
  [Boolean]$compressUpdates = $True
  [Boolean]$obsoleteComputers = $True
  [Boolean]$unneededContentFiles = $True
  [void][reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration")
  $Wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::getUpdateServer($updateServer,$useSecureConnection,$portNumber)
  $CleanupManager = $Wsus.GetCleanupManager()
  $CleanupScope = New-Object Microsoft.UpdateServices.Administration.CleanupScope($supersededUpdates,$expiredUpdates,$obsoleteUpdates,$compressUpdates,$obsoleteComputers,$unneededContentFiles)
  $CleanupManager.PerformCleanup($CleanupScope)

  it's works fine on upstream. but on downstream gives this error:

  The WSUS administration console was unable to connect to the WSUS Server Database.
  Verify that SQL server is running on the WSUS Server. If the problem persists, try restarting SQL.
  System.Data.SqlClient.SqlException -- Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
  The statement has been terminated.
  Source
  .Net SqlClient Data Provider
  Stack Trace:
     at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)
     at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetUpdateServerStatus(UpdateSources updateSources, Boolean includeDownstreamComputers, String updateScopeXml, String computerTargetScopeXml, String preferredCulture, ExtendedPublicationState publicationState, UpdateServerStatusPropertiesToGet propertiesToGet)
     at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetStatus(UpdateSources updateSources, Boolean includeDownstreamComputers, UpdateScope updatesToInclude, ComputerTargetScope computersToInclude, UpdateServerStatusPropertiesToGet propertiesToGet)
     at Microsoft.UpdateServices.Internal.BaseApi.UpdateServer.GetReplicaStatus(UpdateSources updateSources)
     at Microsoft.UpdateServices.UI.SnapIn.Common.CachedUpdateServerStatus.GetFreshObjectForCache()
     at Microsoft.UpdateServices.UI.AdminApiAccess.CachedObject.GetFromCache()
     at Microsoft.UpdateServices.UI.SnapIn.Pages.ServerSummaryPage.backgroundWorker_DoWork(Object sender, DoWorkEventArgs e)

  what could be the problem?
  thanks in advanced.

  • Antworten
  • Zitieren