Thread: Truncate MS SQL 2008 Database Log File

If you need to truncate the SQL database log files to keep them smaller in size. The process I am demonstrating here is for MS SQL 2008.–Get in the database use Test
GO
–see current file sizes
SELECT name,size from sys.database_files
–see current recovery model
select name,recovery_model_desc from sys.databases
–According to the articles if you switch the Recovery Model to Simple inactive part of the transaction log should be removed in MS SQL 2008.
–This command will reduce the log file somewhat
Alter database Test SET Recovery simple
–check if the recovery model is changed
select name,recovery_model_desc from sys.databases
–check file sizes
select name,size from sys.database_files
–changing the recovery model to Simple might not reduce the size enough. to reduce it further
DBCC SHRINKFILE (N’Test_log’ , 1)
–check file size
select name,size from sys.database_files


Source: Truncate MS SQL 2008 Database Log File

Thank for sharing this Information it's good.

Originally Posted by sinc

Thank for sharing this Information it's good.

I have a website with huge database, GBs in size. This works well to keep it manageable

yep you are an expert! can't stop saying it! thanks for this info!

dear if truncate table then you not recover data in future because it remove the schema of table

Good informations regarding the truncate table and its use in data base.Thanks for the posts.