Database Properties (Transaction Log Tab)

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Database Properties (Transaction Log Tab)

Use this tab to view or specify the following options.

Options

Transaction log files

View the file name, location, and space allocated for the transaction log files.

Delete

Delete the selected transaction log file.

Automatically grow file

Specify that the transaction log files grow automatically.

In megabytes

Specify that the transaction log files grow automatically by megabytes (MB).

By percent

Specify that the transaction log files grow automatically by percent.

Unrestricted filegrowth

Specify that the transaction log files can grow without restriction.

Restrict filegrowth (MB)

Specify the size, in megabytes, to which a restricted transaction log file can grow.

See Also

Transaction Logs