Delete log files of database

Question

I m heaving a database it's size is increasing countinouslyI want to delete the log files of this how can i do this I want to truncate the database

Hirendra Sisodiya · Answer

hello ali If you know that a log file contains unused space that you will not be needing than you can reduce the size of the transaction log. this is known as shrinking the log file. (you can got to MSDN: http://msdn.microsoft.com/en-us/library/ms178037.aspx ) Shrinking can occur only while the database is online. open your sql management studio--> Right click on database--> goto task--> shrink --> files than shrink files dialog box will be open you can select Filetype as 'log' and can see neccessary information about log fileselect shrink action and click on 'OK'. thanks Please mark as answere if it helps