• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

WSUS DB req.

We are trying to setup WSUS 3.0 sp2. I am unable to find out the DB req. We will be installing it on a SQL 2005 SP2 clutser, however I need to let the DBA know the DB size. Is there any documentation regarding this?
0
VMwareLover
Asked:
VMwareLover
  • 4
  • 3
  • 2
1 Solution
 
Donald StewartNetwork AdministratorCommented:
0
 
The-JimmyCommented:
Hi!
All that info is in the Release Notes. You can get it here:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ba94a0d3-f22a-4e24-877e-6be6ce5da6d7&displaylang=en

Here's the bit you're looking for:

WSUS Server Hardware Minimum Requirements

¿¿Both the system partition and the partition on which you install WSUS 3.0 SP2 must be formatted with the NTFS file system.
¿¿Minimum 1 GB of free space on the system partition.
***>>>¿¿Minimum 2 GB of free space on the volume on which database files will be stored.
¿¿Minimum 20 GB of free space is required on the volume on which content is stored, 30 GB is recommended.

Greetings,

- Jimmy
0
 
Donald StewartNetwork AdministratorCommented:
Pretty sure the grid from the link I provided showed all that info(without the need to download a doc)
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
VMwareLoverAuthor Commented:
According to the link, it seems the DB only needs to be 2 GB, will it get any bigger at some point or that is just how big it will get?
0
 
The-JimmyCommented:
As you can see, it says Minimum, so yes it could get bigger depending on data.
Thats why they give a global minimum:
-->Minimum 20 GB of free space is required on the volume on which content is stored, 30 GB is recommended.

- Jimmy
0
 
VMwareLoverAuthor Commented:
Jimmy I am talking abbout the DB size not the content volume

dstewartjr your link seems like what i am looking for.. only I am trying to deploy 3.0 sp2, will this still be good, and also is the 2gb DB size minimum?
0
 
Donald StewartNetwork AdministratorCommented:
Yes, I've seen it grow to 6gig at times
0
 
Donald StewartNetwork AdministratorCommented:
0
 
The-JimmyCommented:
Ya sorry, my bad, the 20Gb is indeed for the content.

Nevertheless, DBs do grow depending on data, usually by 2Mb increments. (This can be configured at the DB level).

Cheerios,
- Jimmy
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now