Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 could not read and latch page (1:954) with latch t
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gavis
Starting Member

South Africa
39 Posts

Posted - 06/12/2009 :  06:02:54  Show Profile  Reply with Quote
hi
i get this error when i run a dbcc checkdb
any help will be appreciated

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 06/12/2009 :  09:42:11  Show Profile  Reply with Quote
Run DBCC CheckDB dbname with ALL_ERRORMSGS and post the results

Terry

-- Procrastinate now!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/12/2009 :  10:15:58  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Also the No_INFOMSGS option is useful to remove the informational messages that are of no interest in corruption cases.

DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS


Do you have a clean backup of this database?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

gavis
Starting Member

South Africa
39 Posts

Posted - 06/12/2009 :  10:29:18  Show Profile  Reply with Quote
hi terry
here is the message.

msg 8966, level 16
could not read and latch page (1:954) with latch type SH. sysindexes failed.
please contact you system administrator.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/12/2009 :  14:13:15  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Do you have a backup?

You've got irreparable corruption there. CheckDB cannot and will not attempt to fix the system tables.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/ There's a section towards the bottom on how to 'fix' irreparable corruption. Your options are limited. You can restore a clean backup or you can script out what you can, bcp out what data you can and create a new database.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

gavis
Starting Member

South Africa
39 Posts

Posted - 06/13/2009 :  02:31:12  Show Profile  Reply with Quote
hi.
great feedback, i did restored and imported missing data between the
two databases.

Thanks Again
--

Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/13/2009 :  07:08:59  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Glad you got it sorted.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000