Empty log file size:

Empty log file size:

It is used to trunctae/Reduce size of log file in sqlserver 2005.
This is outdated for sqlserver 2008.

Example:

Our data base size 30GB. log file size 20GB, and mdf file size 10GB.

Then the requiremnt comes like reduce log file size. Then we will go with follwing mechanizam, If we dont need log file tractions.


backup log [databasename] with truncate_only
go
DBCC SHRINKDATABASE ([databasename], 10, TRUNCATEONLY)
go

After exucuting above statement let check your log file size. Absolutly it size reduces.