Richard Thomsen commented on Nov 29, 2007


==== text added to the parent post because of this comment by Harry Peebles ====

RM_No_Log_Objects_In_Mailbox=1 disables transaction logging for all files, no matter what their database property is set to. Using this setting ensures that transaction logging is disabled during execution.

MAILBOXDISABLETXNLOGGING=1 disables transaction logging in a file when the file is automatically created by the server. Using this option ensures the setting of the database property for newly created files, but not for preexisting files.

If you want to disable transaction logging for files, use both of these setting so that 1) the logging is disabled for all cases, and 2) the database properties are consistent with the run-time behavior, thereby reducing opportunity for confusion.

==== text of this original comment post ===

What's the difference between this setting and MailBoxDisableTXNLogging=1, Technote 1090763?