Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This question came from our site for professional and enthusiast programmers.

2

So have you detached the .mdf from your dev server, and copied it to the production server??? In order to attach it, the .mdf file (and any additional .ndf and .ldf files that make up the database) must be on the production server's local disks (or a UNC path the server can get to)
–
marc_sJan 10 '12 at 8:23

@marc_s Marc_s You hit the jackpot. I knew it must be some silly mistake or something that went pass my mind. Do you mind explaining more about the UNC Path? The url i provided at step (2) is that of the production server which i dont have access to. But i know the person who does. Does it mean that everytime i want to update my database, i have to give him the file and ask him to replace the existing database.mdf with the updated database.mdf? Aren't there any more convenient methods to do this?
–
user1079650Jan 10 '12 at 9:03