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: Re: tempdb is huge Date: Thu, 7 Jun 2012 13:54:17 -0700 (PDT) Organization: http://groups.google.com Lines: 8 Message-ID: <97364310-4de1-4c1d-85bd-7324070db259@googlegroups.com> 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 1339102457 21291 127.0.0.1 (7 Jun 2012 20:54:17 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 7 Jun 2012 20:54:17 +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: 1428 Xref: csiph.com comp.databases.ms-sqlserver:1111 Ok I did a sqlservr -f and which started it in single user mode with minima= l configuration. I was then able to restore master.bak I had from a week a= go and that at least let me start up the server. I can see that tempdb is = now only 50 GB, much better than that 200 GB it was before. I guess I'll s= oon find out if it caused any problems!