• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9981
  • Last Modified:

How to recreate SUSDB

I'm running Windows 2008 SBS SP2

When I view <MyServer>\MICROSOFT##SSEE using SQL Server Management Studio 2005 and right click on SUSDB and then left click on Properties I get the error message:
"Unable to open the physical file "C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\DATA\MSDBData.mdf". Operating system error 2: "2(error not found)"."
which is true - msdbdata.mdf does not exist on the disc.
Is it possible to recreate it?
Regards
Clinton
0
ClintonK
Asked:
ClintonK
1 Solution
 
tomcahillCommented:
Can you recover it from a backup?  

to re-create it I think you will need to re-install WSUS.
0
 
ClintonKAuthor Commented:
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
0
 
tomcahillCommented:
hmm indeed.  Are you able to remove it manually from the control panel?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
tomcahillCommented:
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
0
 
ClintonKAuthor Commented:
ok. I was looking for it in Add Remove Programs but no sign
0
 
ClintonKAuthor Commented:
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?
0
 
tomcahillCommented:
Yes, it should still run.
0
 
ClintonKAuthor Commented:
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.
0
 
tomcahillCommented:
do you have another system you can just copy them from?
0
 
ClintonKAuthor Commented:
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
0
 
ClintonKAuthor Commented:
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.
0
 
ClintonKAuthor Commented:
I have finally managed to reinstall WSUS and recreate SUSDB with the following steps:
Using REGEDIT locate: HKLM\Software\Microsoft\Update Services\Server\Setup and change the value of wYukonInstalled from 1 to 0
From Disc 2 of the Windows install CD's, run CMPNENTS\WSUS\WSUSSetup.exe to uninstall WSUS
Uninstall Windows Internal Database
On 32-bit platforms: msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe
On 64-bit platforms: msiexec /x {BDD79957-5801-4A2D-B09E-852E7FA64D01} callerid=ocsetup.exe
Delete files from %windir%\SYSMSI\SSEE directory

From Disc 2 of the Windows install CD's, run CMPNENTS\WSUS\WSUSSetup.exe to install WSUS

Note:Connect to the Internal Database using SQL Server Management Studio using server name "np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query" and Windows Authentication
1
 
ClintonKAuthor Commented:
These five steps are the collection of information from a lot of searching and trial and error. It worked for me.
0
 
pgeipelCommented:
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.
1
 
James CartashCommented:
pgeipel you saved my day!
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now