No space inTemp DB

• Jayanthi-243119

  SSC Rookie

  Points: 25

  More actions

  July 5, 2005 at 12:27 am

  #86740

  Hello Friends,

  I am newbie to SQL server. When a procedure is run, an error is thrown as mentioned. Could anyone suggest a solution to this.

  Thanks in advance.

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  July 5, 2005 at 1:56 am

  #570805

  Increase the disk space of the TempDB

  right click the tempdb, go to properties

  at the data files tab,

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• zach_john

  SSCertifiable

  Points: 5922

  More actions

  July 5, 2005 at 1:45 pm

  #570998

  You can always increase the size of TempDB but you should be asking why is it growing?

  How big is TempDB and where is it currently stored, do you have room to grow, what is this process that requiring TempDB to grow?    Right click tempdb go to property or from Query analyzer run sp_helpdb 'tempdb' .

  Regards,

  Zach

   

  
  John Zacharkan

• vinod-228002

  SSChasing Mays

  Points: 608

  More actions

  July 6, 2005 at 5:29 am

  #571155

   

  H!!,

   

  you can move tempdb to a diffrent drive with more space using the command listed below..

   

  USE master

  go

  ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME =

  'D:\mssql\data\\tempdb.mdf')

  go

  ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME =

  'E:\mssql\data\templog.ldf')

  go

  regards,

   

  Vinod (DBA)

  HTC Global Services

  Ph 09840856202

• David Paskiet

  SSCrazy

  Points: 2949

  More actions

  July 8, 2005 at 10:26 am

  #572496

  Moving it to another drive and increasing it's size is a workaround.  Follow Zach's advice and find out why it is growing first.  If you cant control that, you will always run out of room.

  Kindest Regards,
  David

  ** Obstacles are those frightening things that appear when we take our eyes off the goal. **