Discussion Locked

MSDE attaching a database

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all.. I'm having some trouble trying to attach a database in MSDE. I was able to successfully detach the database 2 weeks ago and I let the database sit out there and now I want to reattach the database so I can view the contents. I am running the script:
sp_attach_db @dbname = 'DatabaseName',
@filename1 = 'C:\TempFileLocation\Database.mdf'

I am receiving an error "Cannot associate files with different databases" Nothing has changed on this server since I ran the detach. The log file is not an issue here because I don't need it. I tried attaching the database in SQL 7.0 and I got a message that the sort order was 52 and my SQL Server has a sort order of 54 so that didn't help out much. I read Microsoft's Q article Q281122. This explains that it's possible that there is a different GUID on the database I'm trying to attach but I don't see how that's possible because I haven't touched the database or the server since I detached it 2 weeks ago. This makes no sense to me.Anyone ever seen this before?

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.