WSUS 3.0 internal database location

It's late, I'm tired...

and I can't find the WSUS 3.0 database file to see how big it is.  I upgraded from WSUS 2.0 with a 1.4gb database.  The 1.4gb database file is now gone, and I want to know if the internal database is bigger, smaller, same.

Help!
snowdog_2112Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SteveH_UKCommented:
This article: http://technet2.microsoft.com/windowsserver/en/library/6f51cae4-4b1e-4a4b-81ef-cc92dd3644fd1033.mspx?mfr=true

indicates that some files are stored in %windir%\SYSMSI\SSEE.

My memory is that the majority are stored in the WSUS folders.  Remember as well that the majority of the content is not actually in the database but is stored in files on disk, described here: http://technet2.microsoft.com/windowsserver/en/library/6f51cae4-4b1e-4a4b-81ef-cc92dd3644fd1033.mspx?mfr=true.

The best bet for finding the database is to look in the registry at HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server.  You are looking for an instance named SSEE and it should indicate the path in this part of the registry.  First you look up the instance name in "Instance Names", and the data part indicates which folder the master database is stored in.  Other database files are indicated from within the master database.

If you install the SQL Server client tool such as SQL Server Management Studio Express, you can easily find more information by connecting to the database.  You need to use this connection string:
np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
0
snowdog_2112Author Commented:
I know where the content is -- I've already moved that to a non-redundant drive to free space in my disk array.

I see the \SYSMSI\SSEE folder and some default SQL databases, but the \data folder inside has just the typical default databases.  The full path is: C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

There is a mssqlsystemresource.mdf file, but that doesn't appear to be what I'm looking for.

Isnt' there a MS resource somewhere that describes where the heck they store data?

I can't connect to it using the Mgt Studio on another server.  Where do I enter that connection string to make the connection from a remote SQL server?
0
SteveH_UKCommented:
Connecting from a remote server is not easy as you first have to enable TCP/IP.  WUS communicates using named pipes.  I tend to install the SQL Server Management Studio Express tool on the server so that I can manage it.

You then connect using:

\\.\pipe\mssql$microsoft##ssee\sql\query

SSMS Express can then give you all the remaining information.  You probably won't be able to connect remotely because the server will be locked down initially.  You can change this using the SQL Server Surface Area Configuration Manager.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
snowdog_2112Author Commented:
Had to fumble around to get to the place where the connection string is entered.  Could have used a little more explicit direction there...
0
SteveH_UKCommented:
Author's comment:

"Had to fumble around to get to the place where the connection string is entered.  Could have used a little more explicit direction there..."

Sorry.  If you'd posted again I would have given more explicit directions, didn't know how much was straightforward for you.

Thank you for the points.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.