Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

WSUS 3.0 SP2 update (KB972455) fails

Posted on 2010-11-08
4
Medium Priority
?
2,143 Views
Last Modified: 2012-05-10
Hi All,

I am trying to apply windows WSUS update KB972455 however this update will not complete the install as the first phase of the update is the backup of the current WSUS database which fails.
Knowing that the update fails due to the backup failure is useful, however I cannot work out what is stopping the WSUS database backup from working.
I am running the update process from a downloaded version of the update and when started shows that the update can connect to the data base and even creates the SUS.DB file where the backup will be stored, but after a timeout period, the process fails with
2010-11-09 15:06:55  Success   MWUSSetup          Validating pre-requisites...
2010-11-09 15:06:56  Error     MWUSSetup          WSUS is outdated. But this will not block setup (Error 0x00000000: The operation completed successfully.)
2010-11-09 15:07:34  Success   MWUSSetup          Creating database backup...
2010-11-09 15:10:00  Error     MWUSSetup          ExecuteQuery: Failed to execute SQL query BACKUP DATABASE SUSDB to DISK=N'H:\WSUS\{23D11CFD-E8EB-4439-B93C-4C82304E8F41}\SUSDB.bak' (Error 0x80040E14)
2010-11-09 15:10:00  Error     MWUSSetup          ExecuteQueryGetNoResults: Failed to execute query BACKUP DATABASE SUSDB to DISK=N'%s' (Error 0x80040E14)
2010-11-09 15:10:00  Error     MWUSSetup          BackupDatabase: Failed to backup database (Error 0x80040E14)
2010-11-09 15:10:00  Error     MWUSSetup          CUpgradeDriver::PerformSetup: Failed to backup database (Error 0x80040E14)
2010-11-09 15:10:00  Error     MWUSSetup          CSetupDriver::LaunchSetup: Setup failed (Error 0x80040E14)
2010-11-09 15:18:40  Error     MWUSSetup          CWatsonHelper::Init: Failed to load WER library. (Error 0x8007007E: The specified module could not be found.)
2010-11-09 15:18:40  Error     MWUSSetup          CSetupDriver::ReportFailure: Failed to initalize the CWatsonHelper.  This is expected on pre-Vista machines. (Error 0x80004005: Unspecified error)
2010-11-09 15:18:40  Error     MWUSSetup          DoInstall: Wsus setup failed (Error 0x80040E14)

I am using MS SQL SERVER 2005 (installed with the last version of WSUS 3.0 sp1).
The database instance is MICROSOFT##SSEE

The server is a 2003R2 SP2 server fully patched

Any ideas
0
Comment
Question by:oratek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 2

Expert Comment

by:mcsjohn
ID: 34090585
A few ideas:
- make sure the rights are setup for H:\WSUS (including NETWORK SERVICE account)
- do you have enough space on drive H for the backup?
- make sure quotas are not enabled or there are big enough for the backup
0
 

Author Comment

by:oratek
ID: 34097640
hi mcsjohn

Thanks for the suggestions.
- The rights on the H:WSUS folder include all administrators and the network service account with full rights.
I don't think file rights are an issue as the update process happily creates the backup folder and SUS.DB file. It just seems to stop at the point of actally exporting the data.
- H drive current has approximately 150Gb free space
- There are no quotas enabled on this server on any of the volumes.

This problem seems to be more evil.
0
 

Accepted Solution

by:
oratek earned 0 total points
ID: 34272497
For those of you interested, KB972455 is not supported on Server 2003R2. This is a fact missed out in the general blurb of KB972455 on Microsoft's web site, but found in the release notes for the KB article.

Interestingly enough, however, the WSUS seems to allow the KB article to be listed as a needed update on Server 2003R2 even when it cannot be installed.
0
 

Author Closing Comment

by:oratek
ID: 34299580
I accepted my own comment as the solution as it is the only solution and nobody else bothered to comment except for one very helpful expert.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

596 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question