Re: SUSDB.mdf = 3.3GB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In article <MPG.236a9476d5b579b9899f0@xxxxxxxxxxxxxxxxxx>, hard@xxxxxxx
says...
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.

PS: if yer looking for the .sql to optimise the WSUS database, well, I
can't find it on MS (but that's where I got it from).

You can get it from my site if yer want (please ignore the guff at the
bottom of the page, for another person).

http://www.adrock.com/Default.aspx?tabid=361

You'll see a pic of the SQL Server Management Studio, after the sql's
been run, and a link you can right-click and download to get a zipped
copy of the .sql file.

--
Duncan
.

Relevant Pages

  • Re: Redundancy design in SBS Domain
    ... But virtualization was not on my radar, and Exchange and SQL need more with each iteration. ... I originally went the SBS route because it was by far the cheapest was to get a server up and running with SQL Server at the time. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 Std - SQL Eval expired...will un-installing break SBS fun
    ... I agree with Claus that you're able to remove SQL 2005 instances if you did ... you can get SBS R2 which already contains SQL Server 2005 ... Workgroup Edition, and upgrade Sharepoint instance, and install other ...
    (microsoft.public.windows.server.sbs)
  • Re: sharepoint error
    ... If you are using SBS 2003 Premium Edition the easiest way is to follow ... to upgrade the SharePoint named instance. ... and search on "Migrating from WMSDE to SQL Server" ... Microsoft Small Business Server Support ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)