Re: SUSDB.mdf = 3.3GB

In article <c6f22b79-a9a9-4f69-80eb-
108be3e6126a@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
jhunter@xxxxxxxxxxxxxxxxxxxxx says...
On Oct 22, 6:58 am, Jim Behning SBS MVP
<jimbehn...@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
On Wed, 22 Oct 2008 15:18:11 +1300, Duncan McC <h...@xxxxxxx> wrote:
In article <5a5972fa-16aa-49fe-b39b-f84a2dc07dd8
@v16g2000prc.googlegroups.com>, jhun...@xxxxxxxxxxxxxxxxxxxxx says...
My c:\wsus\mssql$wsus\data\susdb.mdf is 3.39GB in size (on my SBS2003
SP2 box). Is that normal? Can I move it to my D: drive?

Hopefully you'll see my other post, but yes, search for the wsusutil.exe
util that is on the Server, and use that to move the content.  (I
wouldn't worry about the database, it's very small by comparison).

When I see a database or logs or anythng wsus related that big I clean
it up. All of mine are relatively small. Les has posted some info on
tools you can schedule to run regularly but I just run the gui to
prune old stuff.
See what SBS support is working onhttp://blogs.technet.com/sbs/default.aspx
Check your SBS with the SBS Best Practices Analyzerhttp://blogs.technet..com/sbs/archive/tags/BPA/default.aspx

I hate to ask such a stupid question but which gui and how do I launch
it?

The WSUS 3 one presumably :) ...

Start, ADministrative Tools, Microsoft Windows Server Update Services
3.0 SP1

Go down to OPtions, and you'll see a clean up option.

I also run a WSUS database cleanup SQL script after running it which
optimises the indexes.

--
Duncan
.

Relevant Pages

  • RE: Reinstalled WSUS 3.0 SP1 Now Issues
    ... Follow Up For Microsoft SBS Public Newsgroup Post [Reinstalled ... WSUS 3.0 SP1 Now Issues] with Gary Wang ... Typically I managed the SBS server ... | The Server Computers group was not found: ...
    (microsoft.public.windows.server.sbs)
  • RE: Cisco801
    ... Routing Table on the SBS 2K3 server. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... You just need to add the database IP ...
    (microsoft.public.windows.server.sbs)
  • RE: DST Update KB931836 Failure
    ... Can I assume that you have already run the CEICW on the SBS ... Do you see a rule named 'SBS Microsoft Update Site Access Rule'? ... please run the CEICW on the SBS server. ... Run MPSRPT_WSUS.exe on the WSUS server and send me the report it had ...
    (microsoft.public.windows.server.sbs)
  • I broke Sharepoint :(
    ... SBS was installed and the server was up and running including the default ... After 2 days I was looking at SQL backups I relaised that Sharepoint ... database and the other instances were not migrated accross. ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint not working anymore
    ... a way to rebuild the master database (which you can think of as the database ... Microsoft Small Business Server Support ... SBS Newsgroups: ... >> You mentioned that you had set out to install SP1... ...
    (microsoft.public.windows.server.sbs)