asked on

Confirmation deleting WSUS database.

Working on a SBS2011 experiencing the usual SBS WSUS errors that create disk space issues. I decided to clean up the WSUS database by following two articles.

Reinstall WSUS on SBS tried removing from add and remove programs and it errors out. As mentioned in this article I proceeded to the document below to remove the role but have a database question prior to deleting.

WSUS uninstall is failing I made the changes to the registry mentioned in this article and removed the role which completed successfully. Step 10 states, once WSUS is uninstalled, manually remove the WSUS content and/or database files from the hard drive. This is where I would like to clarify before deleting data. For obvious reasons I want to make sure what I’m deleting will not cause an instability.

My understanding of SQL is it’s installed on the C: partition below where the system databases are displayed. Rather than tamper with the SQL installation the only data I removed here was the log files which grew over 12G. FYI I copied them for further review.

SQL system files located C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\ with the following folders:
Backup
Binn
Data
Install
LOG (12.8G) cleaned up the log files
SchemaSig

On the D: partition there is D:\WSUS with the following folders:
UpdateServicesPackages
WsusConent
SUSDB.mdb (26.5G)
SUSDB_log.ldf (2.6G)

I opened SQL Studio and see the following SUSDB database

Would like a second opinion deleting this database is the correct WSUS database mentioned in the second article above. As well I assume It’s better to right click and select delete rather than remove from the directory, correct.

SQL shows the SUSDB file location here

I believe the SQL instability was caused by the updates failing and plan to test this after deleting this database, reinstalling WSUS and testing.

arnold

If you uninstalled, the action you outlined is the correct way to delete, ...

What is your finall goal here?

If your issues related to wsus crashing and erroring out on data updates, the reason is that when it is deployed the settings for database growth, and transaction log growth settings are too low. In the images it appears you adjusted the growth rate on the transaction log to 10% but left the growth rate on the database file at 1mb which is too low in the current number of products....

5% or 10%

You could relocate the db, Susdb to a different drove, partition.
Wsusutil prior to the uninstall, includes an option to move the content directory to another drive/partition.

I would suggest before going with deleting c:\wsus where content is, to make sure what the end result you wish to end up with before proceeding.

Creating a backup of the db, just in case...

Raja Jegan R

>> I believe the SQL instability was caused by the updates failing

May I know what you are referring as SQL Instability so that we can understand the problem better to recommend better.
Also, let us know what updates are failing, is it the windows updates or WSUS updates..

>> plan to test this after deleting this database, reinstalling WSUS and testing.

If you delete the database and reinstall to get a new databases then chances are that you might not get into issues because your database doesn't have any data at all..
So, I would suggest to identify the real problem and fix it rather than deleting the database..

arnold

Uninstall/reinstall is a risk and is not always resolves .......

The db growth set is too low, 1mb unlimited growth.