Post reply

How to attach 2000 MDF in 2005?

  • March 22, 2006 at 12:17 pm

    #112402

    Has anybody ever taken a SQL 2000 MDF (no log was given to me) and attached it in SQL 2005? It seems no matter what I try I get errors. The last message I received was:

    unable to resolve [log file name]

    We did not specify a logfile name so I am not sure where it is coming from.

    Thanks,

    Patrick

    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • March 22, 2006 at 12:52 pm

    #628205

    Hello Patrick,

    Please go through this link

    http://msdn2.microsoft.com/en-us/library/ms189625.aspx

    It might give you the work out.

    Thanks and have a great day!!!


    Lucky

  • March 22, 2006 at 1:04 pm

    #628210

    Thanks but I have been there quite a bit and I still cannot get it to work. I was looking for a practical example.

    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

  • March 22, 2006 at 1:24 pm

    #628216

    Have a look at sp_attach_single_file_db in bol, don't know if you will have issues running this against 2005 from a 2000 mdf you may want to try and attach first to a 2000 instance and then either detach and attach to 2005 or use backup and restore.

  • March 23, 2006 at 2:09 am

    #628290

    Yes if this error in popup window, then click ok or continue. it is for telling u that there is no ldf file.

    please try this ..

  • March 23, 2006 at 6:09 am

    #628315

    noman - try what?

    Kindest Regards,

    Patrick Allmond
    batteryfuel.com
    For all of your laptop, camera, power tool and portable battery needs.

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

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