SCOM database grooming for operationsmanager DB

  • Article

Problem
=======
SCOM database grooming for operationsmanager DB

Solution
=========
作法一

ALTER DATABASE OperationsManager SET EMERGENCY

Alter database OperationsManager rebuild log on (NAME=mom_log ,FILENAME='E:\SCOMDB\OperationsManager1.ldf')

ALTER DATABASE OperationsManager SET online

作法二

CREATE DATABASE OperationsManager

ON (FILENAME = 'E:\SCOMDB\OperationsManager.mdf')

FOR ATTACH_FORCE_REBUILD_LOG