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 : 11341 | Status : [Member] | Replies : 11
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



Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response