Groups > comp.databases.ms-sqlserver > #1108

Re: tempdb is huge

From	tbone <tony.despain@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: tempdb is huge
Date	2012-06-07 11:47 -0700
Organization	http://groups.google.com
Message-ID	<35cb27a7-4f30-4093-9b97-9b25ecedf98e@googlegroups.com> (permalink)
References	<09bfa005-8f20-4bd6-808a-4e8c609f2b49@googlegroups.com>

Show all headers | View raw

On Thursday, June 7, 2012 11:46:57 AM UTC-6, tbone wrote:
> I am running sql server 2000 and have noticed that the tempdb .mdf file is 200 GB  The largest user db .mdf file is about 130 GB.  I have restarted the server many times but it stays at 200 GB.  It is filling up the disk.  Is there any way to shrink this or is the user db causing it to grow so large?

in an attempt to keep it from getting to big I set the size to what it was currently.  I then removed the tempdb.mdf file so it would get recreated, now I can't even connect...is that because it is recreating the 200 GB .mdf file?  Did I just screw it up?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 10:46 -0700
  Re: tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 11:47 -0700
    Re: tempdb is huge Erland Sommarskog <esquel@sommarskog.se> - 2012-06-07 21:34 +0200
      Re: tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 13:06 -0700
  Re: tempdb is huge tbone <tony.despain@gmail.com> - 2012-06-07 13:54 -0700

csiph-web