How to recreate SUSDB
I'm running Windows 2008 SBS SP2
When I view <MyServer>\MICROSOFT##SSEE
"Unable to open the physical file "C:\Windows\SYSMSI\SSEE\MS
which is true - msdbdata.mdf does not exist on the disc.
Is it possible to recreate it?
Regards
Clinton
When I view <MyServer>\MICROSOFT##SSEE
"Unable to open the physical file "C:\Windows\SYSMSI\SSEE\MS
which is true - msdbdata.mdf does not exist on the disc.
Is it possible to recreate it?
Regards
Clinton
ASKER
I think it was missed from the backup and when we had a disc failure and recovered it didn't come back.
When I try to reinstall WSUS from Disc 2 of the Windows set the wizard starts OK and does a few checks but then fails very soon with the not very helpful message "Setup not completed! The Windows Server Update Services 3.0 SP1 was not removed successfully because an error occurred. To close this wizard, click Finish"
Hmmm
When I try to reinstall WSUS from Disc 2 of the Windows set the wizard starts OK and does a few checks but then fails very soon with the not very helpful message "Setup not completed! The Windows Server Update Services 3.0 SP1 was not removed successfully because an error occurred. To close this wizard, click Finish"
Hmmm
hmm indeed. Are you able to remove it manually from the control panel?
If you can't remove it install the windows cleanup utility remove wsus and reinstall
http://www.softpedia.com/progDownload/Windows-Installer-CleanUp-Utility-Download-18442.html
http://www.softpedia.com/progDownload/Windows-Installer-CleanUp-Utility-Download-18442.html
ASKER
ok. I was looking for it in Add Remove Programs but no sign
ASKER
http://www.softpedia.com/progDownload/Windows-Installer-CleanUp-Utility-Download-18442.html says it's for XP/Vista/Win7. Is it OK for use with Win 2008 SBS?
Yes, it should still run.
ASKER
I think I'm back round to trying to recreate the msdb database files.
WSUS won't install or uninstall and I'm a bit reluctant to use the cleanup utility as there seems to be some indication on the Microsoft site that the utility is no longer available and shouldn't be used.
I think I have two problems: missing msdb and missing SUSDB. Recreating the missing msdb may be the first step I think.
WSUS won't install or uninstall and I'm a bit reluctant to use the cleanup utility as there seems to be some indication on the Microsoft site that the utility is no longer available and shouldn't be used.
I think I have two problems: missing msdb and missing SUSDB. Recreating the missing msdb may be the first step I think.
do you have another system you can just copy them from?
ASKER
Yes, I've just copied the two files from another 2008 server and put them in the folder and restarted SQL. They seem to have been accepted OK
ASKER
Still struggling to recreate the SUSDB database. I've tried restoring from another system but the only ones I have access to are too big and I have my doubts whether that would work anyway. I thought my best option would be to restore from a clean build of 2008 SBS but I've not managed to gain access to one. There must be a way of recreating it - afterall, the build software must do it when Windows is installed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
These five steps are the collection of information from a lot of searching and trial and error. It worked for me.
If you completely delete and cleanup the SUSDB and SUSDB.log files from the SSEE directory or the WID directory on server 2012 I found that the only way to get the files properly recreated was to install the WSUS server on another server just to recreate the SUSDB then had to disable the service and then was able to copy the SUSDB and SUSDB.log to the new server in the proper directory. All has been well.
pgeipel you saved my day!
to re-create it I think you will need to re-install WSUS.