Solved

What maintenance is needed for the Sharepoint database?

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now