error with adding existing *.mdf file as an existing item

Question

I have an existing database(myDatabse) that I created with Microsoft Sql Managenent studio and want to add the myDatabse.mdf file as an existing item(with Visual web Developer express edition)

but get the error message "the file cannot be opened because it is using another process. ..."

In my view it is not open or being used and adding a .mdb file didn't give any problems.

Is there another why one should(can) add the database to the App_data folder so that one can establish a connection to the database.

regards

Software Engineer · Accepted Answer · 2012-06-17 13:33:30Z

1

Generally the running sql server service(s) do not allow to copy database files. To copy .mdf file, detach the database:

Open SQL Server Management Studio
Expand Databases
Right-click on your database > point to Tasks > select Detach > click OK
Manually add the file to App_Folder
After copying, go to Management Studio right-click on Databases > Attach > specify database > click Add

answered Jun 17, 2012 at 13:33

Software Engineer

3,9861 gold badge28 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error with adding existing *.mdf file as an existing item

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related