The best way to go about it is to run the Stored Procedure, p_PartitioningAndGrooming, run by the Rule “Partitioning and Grooming” manually against the OpsMgr database. Changes are it will go wrong as well but it will show additional information about the reasons as well.
- Go to the SQL Server. log on with an account with sufficient permissions and start SQL Server Management Studio;
- Log on to the SQL DB Engine with an account which has sufficient permissions to run the Stored Procedure against the OpsMgr database;
- Right-click on the OpsMgr database, select the option New Query. Copy the Stored Procedure p_PartitioningAndGrooming and hit F5
- Within a few minutes the results will come in, reported under the header Messages:
After solving this error an investigation was started why this database wasn’t backed up successfully for a long time…
Whenever you get the error message Partitioning and grooming has not completed, use this procedure in order to get more detailed error message, enabling you to troubleshoot the issue in a neat manner and avoiding a goose chase.