locked
temp db fullo RRS feed

  • Question

  • My temp db full not suppose to restart the server?

    Any other solution to over come this problem?

    Friday, December 24, 2010 7:51 AM

Answers

  • As of I understand, if you don't have space in your disk where the Tempdb reside, the only way is to restart your server.

    Not sure whether you can shrink it to some extent, which is a bad practice, but in a situation like this, you probably try to shrink your tempdb. but if its completely full, then shrink will not happen, you will need to restart it.


    SKG: Please Marked as Answered, if it resolves your issue.

    • Edited by Sudeepta Ganguly Friday, December 24, 2010 8:04 AM typo
    • Marked as answer by rmd.jilan Friday, December 24, 2010 12:42 PM
    Friday, December 24, 2010 8:02 AM

All replies

  • As of I understand, if you don't have space in your disk where the Tempdb reside, the only way is to restart your server.

    Not sure whether you can shrink it to some extent, which is a bad practice, but in a situation like this, you probably try to shrink your tempdb. but if its completely full, then shrink will not happen, you will need to restart it.


    SKG: Please Marked as Answered, if it resolves your issue.

    • Edited by Sudeepta Ganguly Friday, December 24, 2010 8:04 AM typo
    • Marked as answer by rmd.jilan Friday, December 24, 2010 12:42 PM
    Friday, December 24, 2010 8:02 AM
  • Have you tried adding  file some thing like this in other drive if you have space in other drive....

    USE

     

    [master]

    GO

    ALTER

     

    DATABASE [tempdb] ADD FILE ( NAME = N'tempdev1',

    FILENAME

     

    = N'E:\SQLServer2008\MSSQL10.SQLDEV2008\MSSQL\DATA\tempdb.ndf' ,

    SIZE

    = 2048KB , FILEGROWTH = 1024KB )

    GO


    SNIVAS
    Friday, December 24, 2010 10:19 AM
  • You must define your problem clearly.

    What exactly is your problem? Your SQL Server is running, but your tempdb's data or log files are full? Or you can not start SQL Server service at all for some reason related to tempdb?

     


    Ekrem Önsoy - MCDBA, MCITP:DBA & DBD, MCSD.Net, SQL Server MVP
    Friday, December 24, 2010 12:10 PM
    Answerer