Solved

Tempdb dbcc checkdb errors

Posted on 2003-11-03
10
1,437 Views
Last Modified: 2007-11-27
Hi
I'm having errors (lvl 16) on tempdb :
...
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:3781) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:3782) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:3788) with latch type UP. 2(The system cannot find the file specified.) failed.
....
any info on what might cause this? and how to prevent these.. restarting the sql service will reset the db but it's a live system that can't be shut down..
it's a clustered system with sql server 2000
0
Comment
Question by:Silvers5
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 32

Expert Comment

by:bhess1
ID: 9675318
Try a DBCC CHECKDB on tempDB and see what it reports.
0
 
LVL 34

Expert Comment

by:arbert
ID: 9678688
ummm, why would you do a CHECKDB against the tempdb?  You should only checkdb a database that isn't in use--tempdb for the most part is always in use.  Shutdown SQL server and restart--it rebuilds the tempdb....

Brett
0
 
LVL 32

Expert Comment

by:bhess1
ID: 9680049
arbert - read Silvers5 comments -- "...it's a live system that can't be shut down..."  Thus, I recommended the CheckDB as the only option that I could see.
0
 
LVL 34

Expert Comment

by:arbert
ID: 9680135
chill I can read, thanks for the check though.  Although books online says that you can run CHECKDB on a "live system" if you are running 2000 (you couldn't do it on 7.0), you still can encounter errors from CHECKDB when they don't exist--it's still not very reliable.

If you are running a cluster, issue a checkpoint, fail your cluster over and restart the node after the failover.

Brett
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 20

Author Comment

by:Silvers5
ID: 9857850
I failed over the cluster.. and restarted the sql service.. it was rebuilt.. now I am facing a problem.. the tempdb is not growing.. even if I try to grow it manually the physical file grows but the db doesn't show the growth.. If I add an extra file it grows.. but the main datafile doesn't..
0
 
LVL 20

Author Comment

by:Silvers5
ID: 9857865
arbert I'll post 250 points for you for the first issue..
0
 
LVL 34

Expert Comment

by:arbert
ID: 9858321
And when you look at properties of tempdb, it definately is setup to auto grow?  is there anything in the SQL Server log?
0
 
LVL 20

Author Comment

by:Silvers5
ID: 10283684
It was a hardware problem.. After upgrading the raid firmware it went ok..
0
 

Accepted Solution

by:
PashaMod earned 0 total points
ID: 10919333
Closed, 250 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now