Tempdb files and filegroup

• vinod.saraswat

  SSCrazy

  Points: 2395

  More actions

  March 4, 2011 at 12:11 am

  #233606

  Can any one guide how to manage the tempdb files and filegroups.

  Is it a good practice to shrink the tempdb files / add / remove tempdb files as an when needed.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  March 4, 2011 at 1:38 am

  #1294496

  Read this

  http://technet.microsoft.com/en-us/library/cc966545.aspx

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

  http://support.microsoft.com/kb/307487

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