Anthony J Miller commented on Nov 22, 2008

Transactional logging should be enabled for all servers

Does this apply to IBM Power i users as well? I've never gotten a good answer about this question. I personally have never liked running transaction logging because of the potential issues with DR if a failure occurs after running maintenance and prior to getting a backup

Thomas Bahn commented on Apr 23, 2008

Transactional logging should be enabled for all servers

Another benefit of transactional logging, when used together with appropriate backup software, is the ability to restore databases to a certain point in time.

BUT: When you only have one disc (system) and therefore have your transaction logs on the same drive as your databases, turning on this setting will most probably have a negative impact on your performance.

Thomas Bahn

{ Link }