Posted by Erland Sommarskog on 11/19/07 22:32

time management (tatata9999@gmail.com) writes:
> Here's the scoop, I got a generic-purpose database (in the form of
> *.mdb and *.ldf) from a 'reputable' source on the net. But when I
> attempted to attach it to my sql server 2000 with SP3 with EM, it
> failed complaining "Could not find row in sysindexes for database ID
> 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes."

That message appears familiar. I seem to recall that is what happens
if you try to attach an SQL 2005 database on SQL 2000. As far as
SQL 2000 that is a database that is alien, and for which it cannot
really have any graceful handling off.

> Then, I attempted to command line attach (thought it may have some
> option...), same outcome. Then, ran a search on this NG, and found
> the following thread,

Which is from 1998, and applies to really old versions of SQL Server.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Backup Files
• Prev in forum: Can I combine Log Shipping and Clustering?
• Thread view: Re: Database attach failed

[Reply to this message]