BigFix Technical Search

Search BigFix

 
Search Areas
BigFix Support Website Knowledge Base
User Forums Main BigFix Website

Looking for info on the BigFix Relevance Language? Try the Inspector Search Engine.

Summary:

How do I change the transaction logging behavior for Microsoft SQL Server 2000?

Solution:

To change the SQL Server transaction type, perform the following steps:

  1. On the BES Server computer, open Start > Programs > Microsoft SQL Server > Enterprise Manager.
  2. Browse to the local computer and right click on the 'bfenterprise' database and go to 'Properties'.
  3. Under the 'Options' tab, change the 'Recovery Model' from 'Full' to 'Simple'
  4. Repeat the steps above for the 'besreporting' database.

Note: Changing the logging type does not affect the ability for the database to effectively recover from errors because the BES architecture uses a different error recovery scheme that is not dependent on full transaction logging.

Note: Setting the transaction log mode to simple can significantly reduce the size of the .ldf file, saving disk space on the BES Server.

Knowledge Base ID:

149

Version Information:  

BES 5.0

Creation Date:

6 Oct 2003 15:43:30

Last Modified Date:

2 Apr 2009 16:23:59