SQL Error

• nisha.lakhwara

  Old Hand

  Points: 330

  More actions

  May 24, 2008 at 1:58 am

  #191498

  Hi,

  While attaching the mdf file for adventureworks database I am getting an error as "SQL-DMO (ODBC SQLState: HY000), Error 602: Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECK TABLE on sysindexes."

  I need help to recover my data.

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  May 24, 2008 at 3:08 am

  #819977

  Hi Nisha,

  It looks like you are trying to attach a higher version mdf and ldf file in lower version.

  i.e you are trying to attach SQL 2005 mdf and ldf in SQL 2000 server and this is not possible, you can't go from higher to lower version!

  Regards..Vidhya Sagar
  SQL-Articles

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  May 24, 2008 at 10:56 am

  #820004

  Yup - AdventureWorks is a 2005+ database.

  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