Post reply

The log for database 'tempdb' is not available

  • March 18, 2011 at 9:50 am

    #247114

    We have a switch rebooted itself overnight. One of the SQL servers shows : The log for database 'tempdb' is not available.

    What should I do? Shall I restart the SQL service? will that work?

    Thanks

  • March 18, 2011 at 10:19 am

    #1300635

    where you drives that the databases resided on, paritcular tempdb on a SAN that was connected through the switch?

    Can you get to the tempdb log file itself on the server?

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • March 18, 2011 at 10:25 am

    #1300638

    Right. A recycle of SQL Services will rebuild TempDB and it's log. But like Shawn said, you need to ensure the underlying file or file path for the tempdb log is OK as a 'first diagnostic' effort. Once the physical/logic disk situation is corrected, then you can work on repairing tempdb/recycling.

    Jim

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • March 18, 2011 at 9:46 pm

    #1300882

    Great, thanks for the help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply