Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
SolvedPrivate

WSUS database limit

Posted on 2015-01-12
7
Medium Priority
?
36 Views
Last Modified: 2016-02-19
I run WSUS 3.2.7600.256 on server 2003 using a sql express 2005 database. I have reached the database size limit; and maintenance tasks will not help.

Is there a way I can reinstall WSUS and switch to Windows internal database while preserving the database and it's links to the stored downloads?

Or is my only route to create a slave wsus that uses WID, synchronize it,  and then convert that to the main server via scripts; That is if that is still possible these days.

Thanks much
0
Comment
Question by:Michael Crehan
[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
7 Comments
 
LVL 70

Expert Comment

by:Scott Pletcher
ID: 40545615
If you can upgrade to SQL Express 2008 R2, the db size is 10GB rather than 4GB.

If the size is spread across multiple tables, you could move a table(s) to different dbs to reduce the size of each one to <4GB.  This can be done transparently to your app.
0
 
LVL 29

Expert Comment

by:becraig
ID: 40545618
Also here are the steps for actually moving the database if you have another version of SQL you need to move it to:
http://blogs.technet.com/b/mwiles/archive/2011/06/17/how-to-move-the-wsus-database.aspx


The main idea is to detach the database on the origin server, then attach on the new / destination server.
Then simply update WSUS with the new server details etc
0
 

Author Comment

by:Michael Crehan
ID: 40545648
Scott, Craig

I appreciate both of your comments very much.

My intention is to use the WID because that has no size limit. I do not want to use full blown sql due to the licensing costs and this is just a windows update server. Scott, I am not sure how the WSUSapplication would deal with tables in separate databases, but interesting possibility. Yes I could run it on full blown sql but that gets very expensive due to the cals required.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 29

Expert Comment

by:becraig
ID: 40545666
The internal database is just another variant of sql, simply detach then reattach to the WID.

You can detach database copy the mdf and ldf files then attach in WID.

I do not have WID available to test, so I cannot tell you if there are any constraints or concerns but it should be that easy :~)
0
 
LVL 47

Accepted Solution

by:
Donald Stewart earned 1500 total points
ID: 40546699
If it were me I would do a complete reinstall of WSUS using WID. This way everything will be fresh and your content directory wont be cluttered with no longer needed updates.
0
 

Author Comment

by:Michael Crehan
ID: 40573444
I found that it did not seem to like anything other than a reinstall/migration as a downstream server and then making that system stand alone.
0
 

Author Closing Comment

by:Michael Crehan
ID: 40573450
Thanks much
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Configuring Remote Assistance for use with SCCM
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

636 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