November 13, 2008 at 1:59 am
Hi,
When I restore the backup file of sql server 2000's database in sql server 2005 I got the following error....
Possible schema corruption.Run DBCC CHECKCATALOG.(Microsoft Sql server Error: 211)
Please give me the solution that i can restore the database in sql server 2005.
With regards,
Sunil.
November 13, 2008 at 2:02 am
I don't think you will be able to restore it with corruption. On the SQL 2000 server, please run the following and post the results.
DBCC CHECKDB(< Database Name > ) WITH NO_INFOMSGS
DBCC CHECKCATALOG(< Database Name > ) WITH NO_INFOMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 2:07 am
When I run the following command...
DBCC CHECKDB( ) WITH NO_INFOMSGS
DBCC CHECKCATALOG( ) WITH NO_INFOMSGS
i received the following error....
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (1:17424) with latch type SH. sysobjects failed.
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 1611738136 (object '1611738136') does not match between 'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 1611738136 (object '1611738136') does not match between 'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 1611738136 (object '1611738136') does not match between 'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 1611738136 (object '1611738136') does not match between 'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 1611738136 (object '1611738136') does not match between 'SYSCOLUMNS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 827800144 (object 'DF_Tender_SubmissionTime') does not match between 'SYSOBJECTS' and 'SYSCOMMENTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 1611738136 (object '1611738136') does not match between 'SYSINDEXES' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 826420151 (object '826420151') does not match between 'SYSCOMMENTS' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Table error: Object ID 1611738136 (object '1611738136') does not match between 'SYSCOMMENTS' and 'SYSOBJECTS'.
November 13, 2008 at 2:15 am
You've got some nasty database corruption there. I don't suppose you have any idea when that started?
I'm not sure how to fix it. Let me see if I can get an expert opinion on this.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 13, 2008 at 10:48 am
Gail pinged me to take a look - I'm busy at SQL Connections this week so haven't been watching the forums.
Unfortunately your database is toast. The sysobjects error from running CHECKDB is saying that one of the pages at the leaf-level of the sysobjects clustered index is unreadable (i.e. corrupt). This error cannot be repaired in any way whatsoever. Your only options are to go back to a previous backup or to extract all the data out into a new database. You will not be able to upgrade this database to 2005 or 2008 ever with this corruption, as part of the upgrade step rejigs all the metadata in the database - in fact this error is no repairable in any version.
I also recommend that you put in a place a regular DBCC CHECKDB job etc etc
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
December 5, 2008 at 11:42 am
Hey Paul,
Thanks..You helped others out here as well.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply