what is maximum size of temp db?

Answer Posted / senthilkumar

Physical Properties of tempdb
The following table lists the initial configuration values of the tempdb data and log files. The sizes of these files may vary slightly for different editions of SQL Server.

File Logical name Physical name File growth
Primary data
tempdev
tempdb.mdf
Autogrow by 10 percent until the disk is full

Log
templog
templog.ldf
Autogrow by 10 percent to a maximum of 2 terabytes

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to check if stored procedure is running in sql server?

703


Name few of the dcl commands in sql?

755


What is temporal table?

664


What is RMS migrations?

1931


How to implement service broker?

748


Are semicolons required at the end of sql statements in sql server 2005?

776


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

131


What is nonclustered index with included columns ?

750


Explain the properties of subqueries in sql server?

775


What are the main differences between #temp tables and @table variables and which one is preferred?

818


Is mysql the same as sql server?

718


Explain what are the database objects? : SQL Server Architecture

800


How to modify existing triggers using "alter trigger"?

744


What is meant by dirty read?

808


What are a scheduled jobs or what is a scheduled tasks?

699