Sunday, March 25, 2012

Can't attach database

HI all, I'm trying to move a mdf from a dev machine onto a production server and when I try to re-attach I keep getting the following error " ...the mdf file is not a primary database file" ...and it won't attach.

It's SS2005, does anyone know why this error occurs.

Thanks

How did you detach the original database?|||

Thanks for the prompt Euan, I just found out the database wasn't detached properly, they just burned it onto a CD directly!..hopefully the correctly detached one will be OK.

No comments:

Post a Comment