Solved

Tempdb dbcc checkdb errors

Posted on 2003-11-03
10
1,447 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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 …
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

738 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