Skip to content

Commit 6a24101

Browse files
committed
Update tempdb log file information for the UI.
1 parent a5827b8 commit 6a24101

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/sql-server/install/instance-configuration.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -399,7 +399,7 @@ This topic describes some of the configuration pages in the [!INCLUDE[ssNoVersio
399399

400400
**TempDB log file** is the name of the log file. It is created automatically. The following settings apply only to **tempdb** log files:
401401

402-
- **Initial size (MB)** is the initial size of the **tempdb** log file. The default value is 8 MB (or 4 MB for [!INCLUDE[ssexpress](../../includes/ssexpress_md.md)]). [!INCLUDE[sssqlv14](../../includes/sssqlv14-md.md)] introduces a maximum initial file size of 262,144 MB (256 GB). [!INCLUDE[sssql15](../../includes/sssql15-md.md)] had a maximum initial file size of 1024 MB.
402+
- **Initial size (MB)** is the initial size of the **tempdb** log file. The default value is 8 MB (or 4 MB for [!INCLUDE[ssexpress](../../includes/ssexpress_md.md)]). [!INCLUDE[sssqlv14](../../includes/sssqlv14-md.md)] introduces a maximum initial file size of 262,144 MB (256 GB). [!INCLUDE[sssql15](../../includes/sssql15-md.md)] had a maximum initial file size of 1024 MB. Because **tempdb** is recreated every time SQL Server starts or fails over you should specify a size that is close to the size required by your workload for normal operation. To further optimize the creation of **tempdb** during start-up, enable [Database Instant File Initialization](../../relational-databases/databases/database-instant-file-initialization.md).
403403

404404
- **Note:Tempdb** uses minimal logging. The **tempdb** log cannot be backed up. It is recreated every time SQL Server starts or when a cluster instance fails over.
405405

0 commit comments

Comments
 (0)