SQL Server Forums
Profile | Register | 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		  New Topic  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  
 New 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.08 seconds. Powered By: Snitz Forums 2000