Solved

What maintenance is needed for the Sharepoint database?

Posted on 2009-04-05
5
949 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 38

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 38

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 38

Accepted Solution

by:
Philip Elder earned 50 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SBS 2007 remove AD ? 10 81
Windows Server Backup - behind the scenes management algorithm 8 105
DNS issues after a power outage 3 60
Moving on from sbs 2008... 36 78
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…
Written by Glen Knight (demazter) as part of a series of how-to articles. Introduction One of the biggest consumers of disk space with Small Business Server 2008(SBS) is Windows Server Update Services, more affectionately known as WSUS. For t…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

756 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