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.
Sets the initial size of the transaction log file.
The File Growth property specifies the growth increment of the transaction
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.
How to create
About designing a database
About Create Database Wizard
Creating a new database
Database file details
Create a new table
Completing the wizard