Maintenance Plan issue

  • hi all,

    while executing the plan Maintenance Plan

    it's giving error like

    the log for database 'tempdb' is not available. check the event log for related error messages

    please help any one

  • It looks like somebody had played with it. have anybody changed its path ?

    post its result

    use tempdb

    go

    sp_helpfile

    go

    you need to ensure the underlying file or file path for the tempdb log is OK

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • You can also run the following:

    EXEC sp_helpdb 'TempDB'

    And check that the path that it shows the tempdb_log file is at is there and the file is there. If the path is valid but somebody messed with the file restart SQL, it will recreate TempDB.

    BTW, if the log file for TempDB is missing, I would imagine that you would be seeng a LOT of errors in your SQL Error Log and Application Log.

    Joie Andrew
    "Since 1982"

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

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