Solved

Tempdb dbcc checkdb errors

Posted on 2003-11-03
10
1,446 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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
 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

820 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