Database Archiving mode

[Former Member]

Hello all,

we are in upgrading BW 3.0B to BW 3.5 on MS Sql 2000. In the part of post upgrade activities, we need to check database archiving mode whether it is inactivation mode or disabled mode. How to check this? if it is disabled, how to activate database archive log mode?

Kindly help us.

kind regards,

Aruna,

[Former Member · Accepted solution]

Hi

Right click on the SAP database in Enterprise Manager - it is called the <SID> of your BW system.

There are three modes availabling - Simple, Bulk or Full.

You should set the mode to Full.

Thanks

N.P.C