Shrinking and reducing database size in sql

Axapta Code solutions   Education and Entertainments  Earn Money its Real  Experience of knowledge  Imortant Weblink collections   Fun and Entertainment   God thoughts   Get Ways to Invest your money   Products overview and details

Summary:

If there is big difference in ldf file and .bak file then you can shrink database to reduce size of database. you can use following method at

Details

use <dbname>
checkpoint
go
backup log <dbname> with truncate_only,
go
dbccshrinkfile(<logfilename>,1000)