Attaching AdventureWorks Database

  • Hi,

    When I tried attaching the AdventureWorks Database to the SQL 2005 I get the following error.

    Msg 1813, Level 16, State 2, Line 1

    Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.

    Msg 602, Level 21, State 50, Line 1

    Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

    Could you please let me know how can I attach the AdventureWorks Database.

  • Looks like you're trying to attach a SQL 2005 database to a SQL 2000 instance.

    Adventure works is SQL 2005, hence can only be attached to SQL 2005 or higher.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • No, I am attaching it in SQL 2005 Management Studio only.. the is SQL Server Authentication.But still not able to attach it.

  • The client tool is management studio, I'm asking about the database engine you're trying to attach to. Thing is, that's a SQL 2000-specific error

    Open a query to the SQL instance you're trying to attach the database to and run SELECT @@Version

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Gila Monster. Thank you very much. I've been trying to figure out what I was doing wrong for the longest time. I didn't realize the error I was getting was because my Sql management studio was connecting to the wrong sql server 2000k instance. You're response to the original posting helped me a lot. 🙂

  • Hi,

    When I tried attaching the AdventureWorks Database to the SQL 2005 I get the following error.

    Msg 1813, Level 16, State 2, Line 1

    Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.

    Msg 602, Level 21, State 50, Line 1

    Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

  • That's a SQL 2000 instance, not SQL 2005 (run Select @@version to prove it).

    AdventureWorks is a 2005 or 2008 database and can only be attached to those versions. Downgrade of a database is never possible.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply