[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5722
  • Last Modified:

Error 602 when attaching Databases

Greetings Experts,

I have a server running coexisting instances of SQL2k and SQL2005.  Recently, databses were dettached and the software reinstalled.  From what I have gathered all servie packs were reinstalled as well.  The databases(10)  themselves were detached using SQLSvr2005, none will reattached.  

Getting:
Error '602' cannot find row in sysindexes for database ID 9, object id 1, index id 1.  Run DBCC checktable on sysindexes.


select @@version = 'Microsoft Sql Server 2000 - 8.00.2039'

This seems strange because I am using QA in 2005.

Also SQL Server Integration Services will not Start regardless of configuration


Your help is greatly appreciated.

0
malc77
Asked:
malc77
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
are u trying to attach the sql server 2005 db in sql server 2000. If so it is not possible, unless the compatablility level is 80
0
 
malc77Author Commented:
thanks for your response....I detached using 2005 and trying to reattach with 2005....
0
 
Scott PletcherSenior DBACommented:
>> From what I have gathered all servie packs were reinstalled as well. <<

The service pack and hot fix / patch levels should be *exactly* the same.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
imran_fastCommented:
Should have taken backup for your database

How are you reattaching the databases?
0
 
malc77Author Commented:
OK....I had to remove 2k and reinstall 05.  For some reason 05 was reading the 2k instance.

Thanks for your help.....


0
 
GranModCommented:
PAQed with points refunded (500)

GranMod
Community Support Moderator
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now