December 26, 2012 at 11:38 pm
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
December 27, 2012 at 2:37 am
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;-)
December 27, 2012 at 4:32 am
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