

In my case it is in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ If it usually under the C:\Program Files\Microsoft SQL Server. Now copy those files to the data directory of your SQLSERVER Express. The easier way to do that is to create a Web Project in Visual Studio and then In the App_Data folder right click and add new database. It's a little hacky but works.įirst you need an empty.

bak file, and all you want is to restore that file to a mdf.
