Why is the 'Onepoint' database set to simple recovery? (NETIQKB12333)

Document ID:7712333
Creation Date:02-Feb-2007
Modified Date:03-Apr-2012
- Micro Focus Products:
  Security Manager

Environment

Security Manager 3.X
Security Manager 4.X
Security Manager 5.X

Security Manager 6.x

Situation

Why is the 'OnePoint database set to simple recovery?

Resolution

By design, Security Manager uses bulk inserts for the majority of transactions performed on the 'Onepoint' database. This essentially bypasses transactional logging, thus the recovery model is set to simple.

Cause

The OnePoint database is set to the Simple recovery model

Additional Information

Formerly known as NETIQKB12333

For more information regarding database recovery, consult Microsoft SQL Books Online.