Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 662
  • Last Modified:

upgrades WSUS to SQL express 2008

I have an SBS 2008 server with WSUS database. The application log is filled with errors relating to the database size being over the 4 gig limit. I am not sure why but it seems to me that it is using SQL 2005 express instead of the internal database.

SQL 2008 express is on this server also. Is there an easy way to update that database to 2008?
0
ajdratch
Asked:
ajdratch
2 Solutions
 
Cris HannaCommented:
Have you run the WSUS Clean up tool?   No there is no easy way to move this over to SQL Express
0
 
arnoldCommented:
You can backup the DB on the sql 2005 instance  and the restore it on the sql 2008 version.  You would then need to reconfigure the WSus to use the DB on the other instance.

One other option deals with setting up another system with WSUS as a replica with its database stored in sql 2008. Once it is synchronized and the data is copied, you can convert the former replica into the master/primary. You can then update your GPO to point to the new server.  Once you see the systems reporting to the new system, you can remove/reinstall wsus on the current with the changes you want and then using it as a replica to the existing master server, once data is replicated, you can revert.

Use the cleanup wizard to delete expired/superseded updates, see whether the DB can be compressed.  Double check the product catalog to make sure you did not choose items that you do not need.
0
 
ajdratchAuthor Commented:
When I run cleanup wizard it comes back with Error: Database Error and their is an option to "reset server node"
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
arnoldCommented:
Check whether the issue is related to a transaction log.

Backup the DB.
You can then upgrade the sql2005 to 2008 instance.
0
 
ajdratchAuthor Commented:
I uninstalled WSUS and re-installed. There was an option to use a new database. so far this seems to be working but I need to give it a day to verify.
0
 
arnoldCommented:
Using a new database means you will need to go through the approval/downloads.
0
 
DonNetwork AdministratorCommented:
Also FYI, The internal database doesnt have the 4GB limitation.
0
 
ajdratchAuthor Commented:
New database worked
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now