URGENT : Error Attaching databases in SQL Server 2000

Posted on 2003-02-23
Medium Priority
Last Modified: 2010-05-18
Will really appreciate any help I can get - urgently. This is the situation : There were problems with our SQL Server and
had to reinstall it. I am trying to attach two databases but am getting an error message -
the same one for both - "Error 5173 : Cannot associate files with
different databases.". Now apparently both the databases initially started off with file names, with updated files
added later on to replace the older ones. When we tried to attach the
older files, they attached beautifully, but the newer files don't. Any
idea how we can fix this problem?
Question by:Roneel

Expert Comment

ID: 8005480
Can you attach them to a different database and then append?

Accepted Solution

yurrea earned 800 total points
ID: 8007549
Check the filenames of your data and log files when you attach the database. Chances are, there's an existing database with the same name.


Expert Comment

ID: 9276426
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.
LVL 34

Expert Comment

ID: 10910573
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.  

I will leave the following recommendation for this question in the Cleanup topic area:

Accept Answer From yurrea

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question