tempdb problem

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
.

Relevant Pages

  • Re: Need input...Creating Indexes on 37 million row table...
    ... your log file is on a separate raid array than the ... If you have tempdb on a separate array than the data you ... etc. I'm running SQL 2K. ...
    (microsoft.public.sqlserver.server)
  • Re: tempdb log claiming its filling up
    ... gigs free. ... >Is the log file for tempdb on the same drive as the ... >> The log file for database 'tempdb' is full. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2000 Performance - 10K vs. 15K
    ... Always have plenty of free space in your data and log files. ... As for moving Tempdb you can use the ALTER ... I'm getting a message in event viewer that the tempdb log file is ... > plenty of disk space. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2008 setup
    ... Ideally, you set up different RAID arrays for your database' s Data File, Log File and TEMPDB and leave the SQL Server binaries on the local drive with OS. ...
    (microsoft.public.sqlserver.setup)
  • Re: tempdb is full
    ... the msg clearly said you ran out of disk space for tempdb. ... you can use the following command to manually shrink the tempdb log file. ... > The log file for database 'tempdb' is full. ... Back up the transaction log ...
    (microsoft.public.sqlserver.server)
Loading