Solved

WSUS SBS2011 remove database?

Posted on 2014-01-04
11
4,863 Views
Last Modified: 2016-02-20
Im running a SBS2011 server and setup wsus so that every workstation gets its updates directly from MS and not from WSUS. But the WSUS database is now 14Gb big and nothing to decrease this size helps. I tried to run the cleanup tool from wsus after de-select all possible products to update. Also tried to use the SQL management tool to shrink the database. But it still remain 14Gb.

- I detach the WSUSDB and can remove the DB. But what is the impact?
- Is it possible to create an new (clean) wsus DB?
- I not use WSUS anymore, so it isnt't an issues when it's gone
0
Comment
Question by:sitpro
  • 3
  • 3
  • 3
  • +1
11 Comments
 
LVL 5

Expert Comment

by:x-help
ID: 39756164
try this solution:

1. Download Microsoft SQL Server Management Studio Express from here. Make sure you select the x86 or x64 version depending on your server architecture.

2. Install SQL Management Studio by selecting all defaults.

3. Open SQL Server Management Studio Express.

4. At the “Connect to Server” dialog, in the Server name field enter the  following string:

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Select Windows Authentication and click Connect.

5. At this point SQL Management Studio Express will make a connection to the Windows Internal Database using a named pipes connection (one of the limitations of Windows Internal Database).

6. Find SUSDB database and you can try to use shrink database tools or other operation: move, delete etc...

here is detailed:

http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx
0
 

Author Comment

by:sitpro
ID: 39756169
"6. Find SUSDB database and you can try to use shrink database tools or other operation: move, delete etc..."


as i said: i allready try to shrink the DB.
0
 
LVL 5

Expert Comment

by:x-help
ID: 39756179
So if you do not need WSUS (you said: I not use WSUS anymore), just disable wsus service and phisicaly remove database (You can use SQL management for database removing and check phisical location for db files)

If you will need this in future, you can try to reinstall/recover wsus by instructions:
http://technet.microsoft.com/en-us/library/gg680316.aspx
0
 
LVL 35

Expert Comment

by:Cris Hanna
ID: 39757519
So if you are not using WSUS to keep server and workstations updated, what are u using?
0
 

Author Comment

by:sitpro
ID: 39757783
2 questions:

1. Is i remove Wsus and the DB, what consequence does this have for the working of the machine?

2. What can i do else to reduce the size of the DB?
0
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 
LVL 35

Accepted Solution

by:
Cris Hanna earned 500 total points
ID: 39757805
Has no consequence to the operation of the server.  However you will need to modify the SBS group policies that direct workstations to look for the updates from WSUS

Is the issue here that 14GB is taking up precious disk space?   Do you have another drive with more space?

Why do you want workstations to update directly?

My suggestion is that you follow the repair guide for WSUS on SBS 2011  http://technet.microsoft.com/en-us/library/gg680316.aspx
0
 
LVL 5

Expert Comment

by:x-help
ID: 39757809
You do not need to remove WSUS completely, if you do not need this, just disable wsus service in administrative tools- > services and just remove DB file.

also remember to modify Group policy for direct windows update from internet on client workstations if you realy do not need WSUS.

In future if you need this again you can follow  http://technet.microsoft.com/en-us/library/gg680316.aspx for repair.

But if you have just disk space problem, just remove DB and recreate it following URL above.
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 39759783
Two things:

WSUS is meant to help reduce bandwidth in your environment, having each client pointed to Microsoft will increase this drastically.

You can move the Database and WSUScontent to another larger drive and not have to worry about disk space problems.

How to Move WSUS Content and Database Files to a Different Volume

http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx
0
 

Author Comment

by:sitpro
ID: 39764552
Ik know the procedure to move the DB and im aslo familiar with the benefits of reducing bandwith, but i'm still hoping for an awnser how to reduze the size of the DB.
0
 
LVL 35

Expert Comment

by:Cris Hanna
ID: 39764915
You indicated that you already performed the WSUS cleanup wizard and used the SQL management tools and neither resulted in the database shrinking.  there are no other secret methods.  The only option in would seem is to uninstall and delete the database file.  Then follow the instructions in the repair guide that I posted the link for to reinstall
0
 
LVL 47

Expert Comment

by:Donald Stewart
ID: 39765252
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now