mdf help

Hi Rajeev,

Let me say it again what you are trying to do. You have a SQL Server Db and it's created under SQL Path in "Program Files", and you want to take it out to your Application's App folder location. Correct?

This is simple,
1-cut or copy the .mdf and .ldf from "Program Files" under your App folder.
2- Drop currently existing database from SQL Server Management Studio, as its referring to "Program Files" .mdf /.ldf.
3- Select Database node, Right-click, Attach and select path of your App Folder to .mdf and .ldf. Attach Db.
4- If Db is not listed, then Refresh Database node.

Hope this will help. In case this doesn't then please elaborate/explain what exactly is your scenario and what you are planning to achieve.

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vidya Vrat Agarwal13y ago
Hi Rajeev,

Let me say it again what you are trying to do. You have a SQL Server Db and it's created under SQL Path in "Program Files", and you want to take it out to your Application's App folder location. Correct?

This is simple,
1-cut or copy the .mdf and .ldf from "Program Files" under your App folder.
2- Drop currently existing database from SQL Server Management Studio, as its referring to "Program Files" .mdf /.ldf.
3- Select Database node, Right-click, Attach and select path of your App Folder to .mdf and .ldf. Attach Db.
4- If Db is not listed, then Refresh Database node.

Hope this will help. In case this doesn't then please elaborate/explain what exactly is your scenario and what you are planning to achieve.

Thanks