Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1111
| 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 <tony.despain@gmail.com> |
| 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> (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 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 |
Show key headers only | View raw
Ok I did a sqlservr -f and which started it in single user mode with minimal configuration. I was then able to restore master.bak I had from a week ago 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 soon find out if it caused any problems!
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar
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