Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    38

    Unanswered: attach Database Error -very URGENT

    hi to all
    I got a probelm with attaching the database. I hv Database Name called "ABC". it is working fine. (contain MDF,LDF files)

    I got new BackFiles from CLient. They sent MDF and LDF Files. But i could't able to attach the database i got the following error while attaching the databse.

    Code:
    Server: Msg 5173, Level 16, State 2, Line 1
    Cannot associate files with different databases.
    I tried with the following query
    Code:
    EXEC sp_attach_db @dbname = N'ABC', 
       @filename1 = N'C:\DataBase\ABC.mdf', 
       @filename2 = N'C:\DataBase\ABC_log.ldf'
    i Tried with EnterPrise Manager also i got the same error. you can see the attachment file to view the ERROR.

    Please Help me .Urgently...
    -- Prasad --

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •