- Detach the database
- Rename the log file
- Attach the database without the log file
- Delete the log file
Highlight the database -> Select Tasks , now select Detach and Click OK
Go to your log file folder -> rename the WSS_Content_log.ldf to be like testDev_log-to_be_deleted, and now go back to SQL Server Management Studio follow these steps -
Highlight Databases -> select Attach and click on Add -> add your database WSS_Content, highlight the log file and click the "Remove" button. This attach WSS_Content.mdf and create a new fresh log file.
And please don't forget to run Defrag on your machine, so that you can enjoy better performance.
No comments:
Post a Comment