Re: tempdb can not delete it

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



--
Andrew J. Kelly SQL MVP


"atx" <atx@xxxxxxxxx> wrote in message
news:eUZ6JZL9FHA.444@xxxxxxxxxxxxxxxxxxxxxxx
> Yes, i 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:
>> 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@xxxxxxxxx> wrote in message
>> news:ec7prwC9FHA.2832@xxxxxxxxxxxxxxxxxxxxxxx
>>
>>>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: ASPState Bug/Security issue
    ... what is the proper way to configure SQL ... >!information does not survives a sql restart unless you ... >!tempdb for storage and I'm fine with the downsides. ... >!the stored procs in aspstate and you are good to go. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Error 1105
    ... I have a production database for financial services. ... some processwill need more tempdb space ... So SQL will auto grow that database. ...
    (microsoft.public.sqlserver.server)
  • Re: tempdb size question
    ... TempDB is the soul of SQL and everything you can do to gain performance, ... For example, SQL OLTP with 4 processors, I create five files, 4 with the same ... database size. ... TEMP be in total? ...
    (comp.databases.ms-sqlserver)
  • Database corrupted since windows reboot
    ... He few weeks ago, some problems on our city, make his computer turn off, then restart. ... And when he turns on the program, the sql server's database where corrupted, and he wasn't able to use it again: unfortunately, the program was using it when the computer turn off. ...
    (microsoft.public.sqlserver.tools)
  • ASPState Bug/Security issue
    ... and configure ASPState (fwk 1.1,non-persistent, sql based ... the stored procs in aspstate and you are good to go. ... You need to assign permissions in tempdb, ... this doesn't survive a sql server restart. ...
    (microsoft.public.dotnet.framework.aspnet.security)