SAP Knowledge Base Article - Preview

1549906 - Microsoft SQL database maintenance plan for PCM

Symptom

It is recommended that you perform regular maintenance on the PCM database to keep it in peek condition and to maintain the performance/reliability of the PCM environment. This KBA shows one way to setup a regular maintenance plan including the following:

  1. Full backups (Daily).
  2. Shrink database (Daily).
  3. Clean up history (Daily).


Read more...

Environment

  • SAP BusinessObjects Profitability and Cost Management 10 onwards including Support Packages (SAP EPM PCM)

Product

SAP Profitability and Cost Management all versions

Keywords

maintenance PCM database, reindexation, Database Integrity, Shrink Database, Reorganise Index, Rebuild Index, Update Statistics, Backup Database

 , KBA , EPM-PCM , Profitability and Cost Management, EPO, PP, AA, Metify , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.