Steps to Perform Database Maintenance for Content Central

Steps to Perform Database Maintenance for Content Central

1. Stop All Content Central Services

  • Ensure all services related to Content Central are stopped to prevent conflicts during maintenance.

2. Stop the ContentCentralAppPool in IIS Manager

  • Open IIS Manager
  • Locate ContentCentralAppPool
  • Stop the application pool to ensure no active connections to the database.

3. Launch SQL Server Management Studio (SSMS)

  • Open SSMS and connect to the Content Central SQL Database.
  • If unsure about the SQL Server and Database settings, refer to Configuration Manager -> SQL Settings for the correct details.

4. Execute the Following Script to Rebuild Indexes

Run the script below to rebuild indexes for all tables in the database:


EXEC sp_MSforeachtable @command1="PRINT '?' DBCC DBREINDEX ('?', ' ', 80)"


5. Restart Services

Once completed:

  • Start ContentCentralAppPool in IIS Manager.
  • Restart all Content Central Services.
<< END >>

    • Related Articles

    • Creating a Report in Content Central

      In order to generate a Report in Content Central you must first log into Content Central with an Admin account to access the Administration section. 1. In the Administration section, go to the "Administration>Report Templates>" section, here you will ...

    • How to Delete a document or documents from Content Central

      In this guide we will be going over how to locate and delete single and multiple documents within the Content Central version 7 interface.  This guide pertains to Content Central version 7.X.XXXX Your user account must either be an Administrative ...

    • Content Central Backup Recommendation

      This applies to Content Central Document Management System. Backup Recommendation In the event of system or server failure, the latest backup can be used to restore Content Central System. For maximum efficiency, the Content Central document ...

    • Change the Catalog of a Document in Content Central

      Unlike other fields, including the Document Type, it is not possible to change the Catalog of a Document in Content Central from the Properties list when viewing the file. However, it is possible to change the Document's Catalog by creating a ...

    • Enabling forgotten password; password retrieval for Content Central document management system.

      This guide applies to Ademero's Content Central Document Management System. This guide is outlined using Content Central Version 7.5.6779. Enabling this setting allows users to see and utilize the "Forgot your password" function on your Content ...