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.

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:

Related concepts
Checking database consistency
Backing up and restoring databases
Importing and exporting data
Replicating databases
Obtaining locking information
Reclaiming unused space