Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

What maintenance is needed for the Sharepoint database?

Posted on 2009-04-05
5
Medium Priority
?
969 Views
Last Modified: 2012-05-06
Hi, I recently came across an excellent post on how to reindex the WSUS database as part of monthly maintenance and was wondering if there is any maintenane tasks such as this that should be performed on the WSS (sharepoint/companyweb) database to keep things healthy.

if there is such a task, is there any chance someone could direct me to or post a script for this, as I would be happy to share the WSUS reindex script I have discovered in return.

0
Comment
Question by:solutionone
  • 3
  • 2
5 Comments
 
LVL 40

Expert Comment

by:Philip Elder
ID: 24074143
As a rule, no.

The WSUS maintenance has to do with the need to clean up the database of old entries as well as remove any updates taking up space that are no longer needed. The tools for that are in the WSUS console under options for version 3. It is the WSUS Cleanup Wizard.

Unless there is a specific need to get into the database bits, things should run just fine.

WSS V3 with SP2 will have built-in tools to fine tune the SQL 2005 Express instance.

Philip
0
 

Author Comment

by:solutionone
ID: 24074169
thanks Philip, I try to keep on top of these things as much as possible, but I am relatively new to the world of SQL.

by the way I received your Blueprint book last month and have been loving, looking forward to the advanced blueprint.
0
 
LVL 40

Expert Comment

by:Philip Elder
ID: 24074276
Thanks for the compliment on the book! :)

Philip
0
 

Author Comment

by:solutionone
ID: 24114247
Hi Philip, I finally found the blog that made me think that SQL maintenance needed to be done on WSUS.

it can be found at
http://duitwithsbs.wordpress.com/2009/02/01/re-index-the-wsus-30-database-via-a-gui/

is this post still relevant when the WSUS cleanup wizard  is run, or does this need to be done as well as...

0
 
LVL 40

Accepted Solution

by:
Philip Elder earned 200 total points
ID: 24123485
It is not a factor in the overall performance of your SBS.

If you run the cleanup wizard from within WSUS v3 on a regular basis, you can expect top performance out of WSUS.

Philip
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

A lot of problems and solutions are available on the net for the error message "Source server does not meet minimum requirements for migration" while performing a migration from Small Business Server 2003 to SBS 2008. This error pops up just before …
In the event you manage a Small Business Server 2003, and you are audited for PCI compliance, there are several changes you must make in order to pass the audit. I can take no credit for discovering any of these fixes or workarounds, but there is no…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

916 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