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