could not find row in sysindexes for database ID 9, Object ID1, index ID 1. Run DBCC CHECKTABLE on sysindexes

Posted by Rajujrk under Sql Server on 2/23/2010 | Views : 14590 | Status : [Member] | Replies : 11

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hai ALL,

Error Message:

could not find row in sysindexes for database ID 9, Object ID1, index ID 1. Run DBCC CHECKTABLE on sysindexes

I received above error message while attach the mdf file in my SQL SERVER 2005 Management Tools..

i cant able to attach it..

Thanks & Regards

Rajkumar J

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Vuyiswamb on: 2/23/2010 [Member] [MVP] [Administrator] NotApplicable

0	what is the version of sql of that mdf ? Thank you for posting at Dotnetfunda [Administrator] Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Abhijit Jana on: 2/23/2010 [Member] [MVP] Bronze

0	I guess this is due to Version compatibility of SQL Server. Can you please confirm mdf file is created from SQL Server 2005 or SQL Server 2000 ? Cheers ! Abhijit Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Abhi2434 on: 2/23/2010 [Member] [Microsoft_MVP] [MVP] Silver

0	Use DBCC DBREINDEX to Recreate Indexes. I dont know if it will work for you, but you may try. www.abhisheksur.com Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajujrk on: 2/24/2010 [Member] Starter

0	its SQL SERVER 2008 Format... I need to attach it in 2005.. Thanks & Regards Rajkumar J Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 2/24/2010 [Member] [MVP] [Administrator] NotApplicable

0	NO no no You cant do that. Thank you for posting at Dotnetfunda [Administrator] Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajujrk on: 2/24/2010 [Member] Starter

0	Is there any converter or any solution to extract the Tables, Stored Procedures from 2008 db that means from 2008 mdf file Thanks & Regards Rajkumar J Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 2/24/2010 [Member] [MVP] [Administrator] NotApplicable

0	What you can do is to attach this mdf file in Sql 2008 and script the whole database and recreate it in 2005. Do you know how to script the whole database ? Thank you for posting at Dotnetfunda [Administrator] Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajujrk on: 2/24/2010 [Member] Starter

0	I know that, but i have 2008 mdf file only.. i dont have SQL SERVER 2008 in my system. but i have SQL 2005.. i need to retreive the all the things from 2008 mdf file.. is there any tool rather than SQL SERVER 2008.. Thanks & Regards Rajkumar J Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 2/24/2010 [Member] [MVP] [Administrator] NotApplicable

0	Eish am sorry you need to install SQL 2008. get the Express Edition from the Microsoft site and when you are done uninstall it. Thank you for posting at Dotnetfunda [Administrator] Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajujrk on: 2/24/2010 [Member] Starter

0	ok fine.. Thanks & Regards Rajkumar J Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Abhi2434 on: 2/24/2010 [Member] [Microsoft_MVP] [MVP] Silver

0	But make sure your mdf files does not exceed 4GB. Express editions have limitation of Database less than 4GB. If it is, you need to get Developer Edition of SQl server. www.abhisheksur.com Rajujrk, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts