Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail From: tbone Newsgroups: comp.databases.ms-sqlserver Subject: tempdb is huge Date: Thu, 7 Jun 2012 10:46:57 -0700 (PDT) Organization: http://groups.google.com Lines: 5 Message-ID: <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 1339091303 3029 127.0.0.1 (7 Jun 2012 17:48:23 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 7 Jun 2012 17:48:23 +0000 (UTC) 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: 1240 Xref: csiph.com comp.databases.ms-sqlserver:1106 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 th= e 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= ?