General discussion


MSDE attaching a database

By tmarcotte ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums