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

The log for database 'tempdb' is not available Expand / Collapse
Author
Message
Posted Friday, March 18, 2011 9:50 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:26 AM
Points: 1,749, Visits: 3,153
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
Post #1080496
Posted Friday, March 18, 2011 10:19 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 8:27 AM
Points: 836, Visits: 2,286
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
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1080517
Posted Friday, March 18, 2011 10:25 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, May 7, 2014 7:16 AM
Points: 650, Visits: 1,265
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
Post #1080520
Posted Friday, March 18, 2011 9:46 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:26 AM
Points: 1,749, Visits: 3,153
Great, thanks for the help
Post #1080795
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse