Post reply

Attaching a database

  • July 11, 2006 at 8:03 am

    #61447

    Hi

    I want to know can we attach the mdf and ldf files of sql server 2000 to Sql 7.0.

    What I mean is that I have a database created in Sql 2000.Now lets say if I go and attach it in sql 7.0 will it work fine . or will there be any problems..

     

  • July 11, 2006 at 8:17 am

    #648483

    You cannot

  • July 11, 2006 at 9:12 am

    #648511

    Nope, but you should upgrade the v7 server to 2000. It can run v7 files and then you have less issues.

  • July 11, 2006 at 4:02 pm

    #648603

    You can not attach but you may be able to import data into the new database 7.0 from 2000. You may also generate scripts in 2000 to create table and other object structure but you have to verify them for compatibility. I would make a copy of the database in 2000, on the copy set compatibility level to 7.0 and then script.

    Regards,Yelena Varsha

  • July 12, 2006 at 7:56 am

    #648714

    You may be able to get them to attach if the compatibility level is set to 70 in database properties - options.  I have done this in the past without any issues.

    Joshua Perry
    http://www.greenarrow.net

Viewing 5 posts - 1 through 4 (of 4 total)

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