SCOM Operational DW Transaction Log is full

Frenz,

          I have SCOM 2012 R2 UR6 environment, it's using SQL 2012 SP1 Availability Group in backend.

          So the Recovery Model is full for both OpsDB and OpsDW. 

Query: Operations Datawarehouse transaction is log full within 2 days of installation (it's 20GB). I have 150 Windows & Network devices to Monitor, Help me with the best practice.

July 24th, 2015 2:50pm

I am not sure if your question is SQL related. If you need to configure retention policy for your datawarehouse database in SCOM you can use dwdatarp.exe (works with 2012 as well) http://blogs.technet.com/b/momteam/archive/2008/05/14/data-warehouse-data-retention-policy-dwdatarp-exe.aspx

Free Windows Admin Tool Kit Click here and download it now
July 24th, 2015 3:10pm

Hi

Either you have a problem with the log shipping or you need to backup the transaction log. Have a chat with one of your SQL DBAs and they will be able to fix this.

Cheers

Graham

July 25th, 2015 8:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics