Is There Any Way to shrink Log file or backup the log content so i could have the mdf and ldf file with a small size

i tried the statement
DBCC SHRINKFILE ( 'diwan_LOG',10,TRUNCATEONLY)
but no way.... the same size, i restrict the Log file size to 100Mega

the strange in that when backup the database it becomes from 120 Mega to 6 Mega(both mdf and ldf files).

Any One Can help



Ahmed Ali
Software Developer

__________________
Ahmed Ali
Senior Software Developer

Hey,

YOu can truncate a log file with:

backup log diwan_LOG with truncate_only

as an alternative, although this may not be what you are looking for?

Brian

After shrinkfile you will have to do a SQL service restart or if you do not want to restart SQL service, then you can dettach and re-attach the db, to get the new shrunk size in effect. Till then you would be seeing the same size for the MDF/LDF file, whichever you shrink

You may want to take a look at this thread, which I originated with something similar to this, and also posted what I did to get that resolved and free up some HDD space.

Shrink Log without SQL service restart.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Actually I Need To Delete The Log File Or Remove Its Contents

i have one way but is there a way else
my way is two generate a script file and make a new db and then import data....

Ahmed Ali
Software Developer