Post reply

Error in attaching a database

  • October 15, 2008 at 4:25 pm

    #75343

    Hi

    I am using 2000 server i am trying to attach a DB from 2005.I just have .mdf and .log file and 2005 is not installed on my system.

    it gives me an error saying

    error 602: Could not find row in sysindexes for database id 7

    so Can u please help me guys?

    Thank You

  • October 15, 2008 at 4:37 pm

    #885577

    SQL Server 2005 databases aren't backward compatible with SQL Server 2000. You could install SQL Server 2005 Express, attach the database to that, and then perform an object level copy to get the database transfered to your SQL Server 2000, but I don't believe it will work any other way.

    And then again, I might be wrong ...
    David Webb

  • October 15, 2008 at 10:23 pm

    #885630

    Actually i detached the database from another server which is sql 2005 and i want to attach it to the

    sql 200 server.

    Can i do that ?

    Thank you

  • October 15, 2008 at 11:10 pm

    #885636

    As stated above, no you can't attach a database from SQL Server 2005 to SQL Server 2000 (even if it was in compatability mode 80). The disk structures are different and they aren't backward compatible.

    😎

  • October 15, 2008 at 11:22 pm

    #885639

    tinku.reddy (10/15/2008)

    Actually i detached the database from another server which is sql 2005 and i want to attach it to the

    sql 200 server.

    Can i do that ?

    Thank you

    No you can't. There is no way to attach a database from a newer server's version to an older server's version.

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • October 16, 2008 at 12:12 pm

    #886037

    Okay guys i got it Thanks a lot

  • October 17, 2008 at 8:41 am

    #886405

    However, you could create an empty database on the 2000 box, script all your objects in the 2005 database and apply against the 2000 database, then copy the data using SSIS from the tables in 2005 to the corresponding tables in 2000. There would be some manual work etc but it can be done

  • October 17, 2008 at 9:17 am

    #886446

    Thanks a lot

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

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