Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maintenance Plan issue Expand / Collapse
Author
Message
Posted Wednesday, December 26, 2012 11:38 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, April 20, 2014 10:08 PM
Points: 30, Visits: 158
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



Post #1400473
Posted Thursday, December 27, 2012 2:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 29, 2014 5:01 AM
Points: 2,840, Visits: 3,968
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
Post #1400512
Posted Thursday, December 27, 2012 4:32 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 6:11 AM
Points: 709, Visits: 1,423
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"
Post #1400557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse