Solved

WSUS ?

Posted on 2013-11-14
2
267 Views
Last Modified: 2016-02-13
My wsus .mdf is 4gb. how to reduce the size?
0
Comment
Question by:Hubman
2 Comments
 
LVL 14

Accepted Solution

by:
JAN PAKULA earned 500 total points
ID: 39649412
if you have sql management studio you can do that


1 set your DB to SIMPLE RECOVERY (right-click on DB in SQLMS, go to properties, Options, Recovery Model -> Simple).

2 Then shrink the files - firstly your log file and then your data file. To do so, right-click on DB in SQLMS, Tasks, Shrink, Files. Set FileType to log and and choose "Reorganise pages..." and set as low as you can go. Repeat but set FileType to Data.

3 Set your DB back to FULL RECOVERY if it was on there before you changed to SIMPLE RECOVERY above. If it was already set for SIMPLE RECOVERY then just leave as is.
0
 
LVL 1

Author Closing Comment

by:Hubman
ID: 39649438
I'll give that a try
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

947 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

20 Experts available now in Live!

Get 1:1 Help Now