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

Re: tempdb is huge

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	tbone <tony.despain@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: tempdb is huge
Date	Thu, 7 Jun 2012 11:47:08 -0700 (PDT)
Organization	http://groups.google.com
Lines	11
Message-ID	<35cb27a7-4f30-4093-9b97-9b25ecedf98e@googlegroups.com> (permalink)
References	<09bfa005-8f20-4bd6-808a-4e8c609f2b49@googlegroups.com>
NNTP-Posting-Host	209.20.103.246
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1339094935 8089 127.0.0.1 (7 Jun 2012 18:48:55 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Thu, 7 Jun 2012 18:48:55 +0000 (UTC)
In-Reply-To	<09bfa005-8f20-4bd6-808a-4e8c609f2b49@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=209.20.103.246; posting-account=m5z2xQoAAACdflVHxlKtq0DEgoIcz3yL
User-Agent	G2/1.0
X-Received-Bytes	1712
Xref	csiph.com comp.databases.ms-sqlserver:1108

Show key headers only | 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