How to restore a Corrupt SCOM Database in SCOM 2012 R2
- Sometimes the SCOM database gets corrupted because of disk issue.
- Restoring it from Backup is a very lengthy process and time consuming.
- Opening a ticket with Microsoft might help, but there default reply is to restore from last good backup
- So how you quickly recovery a corrupt SCOM database?. There is a way.
- First Stop all SCOM Services on your management server.
- Then Put the Corrupt SCOM database in SINGLE_USER Mode.
If you Operations Manager DB is corrupted Run the below command,
If you Operations Manager Datawhare house is corrupted Run the below command,
DBCC CHECKDB ('OperationsManagerDW', REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS, NO_INFOMSGS
- Once completed you should be able to bring your database online
No comments:
Post a Comment