All posts by DAX guy

About DAX guy

Hi, I've been working on application development and an ERP system since more than 7 years. It's been a great journey, working with different people, different environments. For any queries, please contact me on Thanks folks.

How to truncate sql database

Hi all,

Today I want to share with you guys a simple database trick which might helps you when the sql database server disk becomes full.

Before doing this, please take the backup for your database

1. Now go to your sql database server and select your database and right click and go to properties and then select options on your right hand side and set recovery model to simple.

2. Select the database and now go to sql query and run the below command

SELECT file_id, name FROM sys.database_files;

3. Run this below command in sql query


where 2 is the id of the transaction log you get in the step 3

4. set recovery model to full again.

Thats it, you have reduced your sql database size by removing log transactions.