Altering Databases - Transaction Log Files Tab

Increases the size of the existing transaction log files or adds new files to enable more transactions to be performed in the database. The transaction log grows as new transactions are performed in the database. SQL Server truncates the log after it performs a successful database or transaction log backup.

To open this window, on the File menu, choose Database, choose Alter, and then choose the Transaction Log Files tab.

You can also delete existing transaction log files that are empty. The first transaction log file that is listed is the primary file. You cannot delete the primary transaction log file.

See Also

Tasks

How to: Increase the Size of Transaction Log Files
How to: Add New Transaction Log Files
How to: Alter Databases

Concepts

Altering Databases - General Tab
Altering Databases - Database Files Tab
Altering Databases - Collation Tab
Altering Databases - Options Tab
Altering Databases - Integration Tab
Altering Databases - Advanced Tab