Tempdb in sql server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Tempdb in sql server 2005

Tempdb in sql server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

subha.mcts2005

Posted Thursday, October 21, 2010 5:11 AM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 20, 2012 10:01 PM
Points: 76, Visits: 282

Hi

what is maximum size of temp db?

Subha

Post #1008330

hallidayd

Posted Thursday, October 21, 2010 5:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, March 03, 2013 2:50 AM
Points: 112, Visits: 294

It can't get any larger than the disk array(s) it is placed on.

Post #1008332

GilaMonster

Posted Thursday, October 21, 2010 5:35 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

Same as any other database

A little over 500 000 TB.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1008349

Bhuvnesh

Posted Wednesday, October 27, 2010 3:27 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

subha.mcts2005 (10/21/2010)

what is maximum size of temp db?

Seems like interview question ? BigGrin

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1011349

subha.mcts2005

Posted Wednesday, October 27, 2010 3:48 AM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 20, 2012 10:01 PM
Points: 76, Visits: 282

yes..

plz Explain It ?

Subha

Post #1011355

steveb.

Posted Wednesday, October 27, 2010 3:55 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:07 AM
Points: 2,802, Visits: 7,107

the max capacity for sql server can be found here

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Temp Db is like any other so the max size as mentioned would be 524,272 terabytes.

However in practice it would be a LOT less.

If this is an interview question, then it is a fairly bad one..

Post #1011358

GilaMonster

Posted Wednesday, October 27, 2010 4:04 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

Already did.

GilaMonster (10/21/2010)

Same as any other database

A little over 500 000 TB.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1011365

subha.mcts2005

Posted Wednesday, October 27, 2010 4:30 AM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 20, 2012 10:01 PM
Points: 76, Visits: 282

thanks very one...

its good......

Post #1011382

« Prev Topic | Next Topic »

Permissions