Stay informed about any major changes. Click here to subscribe
Transaction log file details
Specifies transaction log file name, initial and maximum size and whether
to grow it automatically, or restrict file growth.
Log File Name
The name of the physical file that will record the changes to the data.
By default, SQL Server places a suffix of _Log to create this name. The
log files are stored on your hard drive with an extension of LDF.
Initial Size
Sets the initial size of the transaction log file.
File Growth
The File Growth property specifies the growth increment of the transaction
log file.
Unrestricted File Size
Specify that the transaction log files grow automatically. The only
limit is the spare space on the hard drive.
Restrict File Size To
Sets a limit on how large the log file is allowed to grow. Filling the
transaction log and not being able to process any more information because
the log is full will cause your SQL Server to stop processing.
