Post reply

Tempdb in sql server 2005

  • October 21, 2010 at 5:11 am

    #242013

    Hi

    what is maximum size of temp db?

    Subha

  • October 21, 2010 at 5:12 am

    #1240187

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

  • October 21, 2010 at 5:35 am

    #1240202

    Same as any other database

    A little over 500 000 TB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • October 27, 2010 at 3:27 am

    #1242721

    subha.mcts2005 (10/21/2010)

    what is maximum size of temp db?

    Seems like interview question ?:-D

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 27, 2010 at 3:48 am

    #1242725

    yes..

    plz Explain It ?

    Subha

  • October 27, 2010 at 3:55 am

    #1242727

    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..

  • October 27, 2010 at 4:04 am

    #1242734

    Already did.

    GilaMonster (10/21/2010)

    Same as any other database

    A little over 500 000 TB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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

  • October 27, 2010 at 4:30 am

    #1242751

    thanks very one...

    its good......

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply