Skip to Content
0
Dec 28, 2010 at 05:31 PM

DB02 Recovery: FULL mode issues compare to SIMPLE

60 Views

Hi SDN Experts,

We have weekly and monthly jobs running in our BW Production system with huge back up transaction logs...Due to these loads we are getting CCMS alerts of t log space issues. When we checked in DB02 the Recovery mode is set to FULL...with log space as 60 GB limit.:

So our DB team has changed the setting to SIMPLE and it is not giving any issues when its changed to SIMPLE. I requested them to change to Simple always but they said Transaction log back up should be FULL always. Can any one let me know what happens if we change this setting to Simple for ever instead of just changing it on weekly and monthly runs?

We have the weekly and monthly BW jobs for Cube compression and PSA deletion and I never faced this issue before when I worked with other places...I guess this is due to simple mode selection though....Please advice

Edited by: ganesh uttitti on Dec 30, 2010 3:52 PM