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

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

793


What are the events recorded in a transaction log?

761


What is the use of builtinadministrators group in sql server? : sql server security

761


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

814


What guidelines should be followed to help minimize deadlocks?

706


In what sequence sql statement is processed?

787


Explain where clause?

761


How do I run a trace in sql server?

708


What are the reporting services components?

110


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1780


What is the main purpose of having conversation group?

694


How and why use sql server?

736


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2563


Tell me the use of keyword with encryption. Create a store procedure with encryption?

783


What to perform pattern match with the like operator?

683