Wednesday, March 26, 2014

Create a Databse only with mdf file



Step 1 – Right click and select the attach the database.

Step 2 – Select the MDF file.





Step 3 – Select the Log file and click Remove.




Step 4 – Click Ok


The database is ready for use. Sql Server automatically creates the LDF file.

No comments:

Post a Comment