SolvedPrivate

WSUS database limit

Posted on 2015-01-12
7
34 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 69

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
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.

 
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 500 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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

728 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