Logging on a separate device You can improve the performance of update-intensive, large databases by putting a database's log on a separate device, which reduces I/O contention. Logging transactions Transaction logputting on separate device Logdefault location for

By default, the transaction log is in the log subdirectory of the database directory. Use either of the following methods to store this log subdirectory in another location: