Environment: SBS Server 2008
DC/ Domain Server: Windows Server 2008 FE
Microsoft Windows Server Update Services 3.0 SP1 - MMC
SUSDB.MDF started at 14.x GB and when trying to use the Updates Cleanup options {will link more detail from an article we found to do that}, it would go on for a long time and then eventually crash and now the SUSDB.MDF file is 24.x GBTried this a few times but it would crash again with no reduction in size.
So we figured maybe uninstall "Microsoft Windows Server Update Services 3.0 SP1" and start fresh by reinstalling it or a more updated version.
The uninstall was asking for a file in a
e:\..long guid like hex number..\...\..
location which was not at the said location nor any other drives or locations on the server.It closed with a uninstall not done properly.
We were unable to delete the MDF files or perform any delete or reduction operations from the SQL Server Management Studio Express.
We figured we could install the latest version: 3.0 SP2 from Microfost here: https://www.microsoft.com/en-us/download/details.aspx?id=5216
And after that try cleanup / uninstall, but this won't install as well, fails and points to the attached file log and there is no Program/ working MMC or Uninstall entry in Programs & Features.
So, what can we do now in such a scenario?
WSUS Install/ Setup Log file:
C:/Users/administrator.COMPANY/AppData/Local/Temp/WSUSSetup.log
2016-05-03 13:41:42 Success MWUSSetup Validating pre-requisites...
2016-05-03 13:41:57 Success MWUSSetup Removing Wsus...
2016-05-03 13:55:48 Error MWUSSetup RemoveWsus: MWUS Uninstall Failed (Error 0x8007064C: The installation source for this product is not available. Verify that the source exists and that you can access it.)
2016-05-03 13:55:48 Error MWUSSetup Wsus MSI uninstallation failed. (Error 0x8007064C: The installation source for this product is not available. Verify that the source exists and that you can access it.)
2016-05-03 13:55:48 Error MWUSSetup CSetupDriver::LaunchSetup: Setup failed (Error 0x8007064C: The installation source for this product is not available. Verify that the source exists and that you can access it.)
2016-05-03 13:55:54 Error MWUSSetup DoInstall: Wsus setup failed (Error 0x8007064C: The installation source for this product is not available. Verify that the source exists and that you can access it.)
2016-05-03 15:05:54 Success MWUSSetup Validating pre-requisites...
2016-05-03 15:05:54 Error MWUSSetup WSUS is outdated. But this will not block setup (Error 0x00000000: The operation completed successfully.)
2016-05-03 15:05:56 Error MWUSSetup ExecuteQuery: Failed to execute SQL query USE SUSDB IF EXISTS (select * FROM master..sysdatabases WHERE name= N'SUSDB' AND suser_sname(sid) is null) EXEC dbo.sp_changedbowner N'COMPANY\administrator' (Error 0x80040E14)
2016-05-03 15:05:56 Error MWUSSetup ExecuteQueryGetNoResults: Failed to execute query USE %s IF EXISTS (select * FROM master..sysdatabases WHERE name= N'%s' AND suser_sname(sid) is null) EXEC dbo.sp_changedbowner N'%s' (Error 0x80040E14)
2016-05-03 15:05:56 Error MWUSSetup CUpgradeDriver::PerformPreSetupActions: Failed to reset database owner name for SUSDB to owner COMPANY\administrator (Error 0x80040E14)
2016-05-03 15:05:56 Error MWUSSetup CSetupDriver::LaunchSetup: Failed to perform pre-setup actions (Error 0x80040E14)
2016-05-03 15:05:56 Error MWUSSetup CProgressManager::EnableCancel: GetDlgItem returning error (Error 0x80070578: Invalid window handle.)