Solved

WSUS ?

Posted on 2013-11-14
2
277 Views
Last Modified: 2016-02-13
My wsus .mdf is 4gb. how to reduce the size?
0
Comment
Question by:Hubman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Let's recap what we learned from yesterday's Skyport Systems webinar.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
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 from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

617 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