Management Reporter Database in Suspect Mode

So you check SQL and notice your backups stop running.

Only to notice it is because your MR database is in suspect mode. To resolve the issue i would first suggest, removing MR from the database backup plan and complete your GP backups.

Then run the below script to resolve the MR suspect mode issue. Then create your separate plan for MR backups.

Script:

EXEC sp_resetstatus ManagementReporter;

ALTER DATABASE ManagementReporter SET EMERGENCY

DBCC checkdb(ManagementReporter)

ALTER DATABASE ManagementReporter SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (ManagementReporter, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE ManagementReporter SET MULTI_USER