Geeks With Blogs
Jawad Khan Jawad's Lodge - The willingness to torture yourself before others is what makes a developer truly a unique breed.

I always get asked how to maintain MCMS database on Production Server. As the website is live for a while its normal to have some resources that are not linked any more or deleted copies of posting version etc. Here is the SQl Script and some Utlility code that will help you maintain your database.

The Support article discusses general best practices for maintaining your Microsoft Content Management Server (MCMS) database by using tools that are included with the MCMS client tools and with SQL Enterprise Manager.

This article also discusses a substitute process for the Background Process (BP). This substitute process includes a SQL stored procedure version of the BP together with an ASP sample script to delete expired postings and to delete expired pages in your MCMS database.

Here is the support Article from Microsoft that has all the details Maintaining MCMS Database

Posted on Friday, May 13, 2005 2:47 PM Microsoft Content Management Server | Back to top

Comments on this post: How to maintain a Microsoft Content Management Server database

# It is a bad idea to copy content from KB articles to a blog entry
Requesting Gravatar...
Jawad has posted a blog entry about how to calculate the Cache Node Size for a MCMS site. Unfortunatelly...
Left by Stefan Goßner on May 17, 2005 2:22 PM

# re: How to maintain a Microsoft Content Management Server database
Requesting Gravatar...
i need a process how to make a back up files and to maintain server
Left by nikko on Nov 12, 2007 4:41 AM

Your comment:
 (will show your gravatar)

Copyright © Jawad Khan | Powered by: