Hi,
after a huge ODBC operation to read some data from a DB table, my tempdb
is now 2.8 GB and I can not delete tempdb. Query analyzer does not work,
right mouse click and delete does not work, dbcc checks does not work. I
even stopped the service and started it again, but tempdb did not
regenerated and still 2.8 GB. I manually deleted the tempdb.mdf file and
log file but after I started the MSSQLSERVER service, they are all
recovered as 2.8 GB.
How can I get rid of this tempdb???
regards,
atx

First of, Why would you want to delete that database? It is vital to the
operation of SQL Server.
If you are concern about disk space you could always try dbcc shrinkfile,
once the database is empty.

It is recreated every time SQL Server is shutdown and then restarted. Are
you saying that once you restarted SQL it was still 2.8GB in size? How big
is your model database?

JD


"atx" <atx (AT) xerox (DOT) com> wrote

Yes, ı konow it is regenerated normally on restart, but it does not
anymore. It is stuck at 2.8 GB. So, by some means I have to delete it.
But how? DBCC shrink does not work also..
regards,
atx


Joe D wrote:

--
Andrew J. Kelly SQL MVP


"atx" <atx (AT) xerox (DOT) com> wrote

http://www.support.microsoft.com/?id=307487

--
Andrew J. Kelly SQL MVP


"atx" <atx (AT) xerox (DOT) com> wrote