MSSQL Server databases used with FactorySQL groups which overwrite the same record repeatedly (for example, bi-directional items) should be placed into the partial backup mode. If this is not done then the transaction log grows huge and slows down database response time. The partial backup mode can be set either from the MSSQL console command prompt or from menu items in Enterprise Manager.
All queries are written to the transaction log. The the database server executes the query from the transaction log. In the full backup mode, records in the transaction log are never overwritten. In the partial backup mode once the query is read by the database engine and executed that record in the transaction log is freed and overwritten later. Therefore the transaction log size stays relatively constant and queries remain fast.
This is very important to know about MSSQL Server.