Post reply

cannot attach DB

  • August 30, 2007 at 11:53 am

    #180500

     

    i detached the database rename the xxx.ldf file.

    attached the database and created a new yyy.ldf.

     

    I tried detaching it again and using the old xxx.ldf file. But its giving me an error that says 'Cannot associate files with different databases.

     

    any ideas know how to fix it?

  • August 30, 2007 at 12:04 pm

    #730536

    You can't, to my knowledge. If I recall correctly (and I'm sure someone else can probably input more here) when you elect to create a new log it alters the data files as well to point to the new log. Trying to re-associate it to the old log can't be done because that reference in the data file is broken.

  • August 30, 2007 at 2:23 pm

    #730590

    by doing so you are de-associating LDF with MDF. As internally  MDF keeps track of LDF & also create new if you do single file attach(MDF).

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

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