InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 09:51:09 GMT20http://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspxthanks very one...its good......Wed, 27 Oct 2010 04:30:25 GMTsubha.mcts2005http://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspxAlready did.[quote][b]GilaMonster (10/21/2010)[/b][hr]Same as any other databaseA little over 500 000 TB.[/quote]Wed, 27 Oct 2010 04:04:28 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspxthe max capacity for sql server can be found here[url] http://msdn.microsoft.com/en-us/library/ms143432.aspx [/url]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..Wed, 27 Oct 2010 03:55:46 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspxyes.. plz Explain It ?SubhaWed, 27 Oct 2010 03:48:20 GMTsubha.mcts2005http://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspx[quote][b]subha.mcts2005 (10/21/2010)[/b][hr]what is maximum size of temp db?[/quote] Seems like interview question ?:-DWed, 27 Oct 2010 03:27:05 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspxSame as any other databaseA little over 500 000 TB.Thu, 21 Oct 2010 05:35:01 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspxIt can't get any larger than the disk array(s) it is placed on.Thu, 21 Oct 2010 05:12:02 GMThallidaydhttp://www.sqlservercentral.com/Forums/Topic1008330-357-1.aspxHi what is maximum size of temp db?SubhaThu, 21 Oct 2010 05:11:07 GMTsubha.mcts2005