Saroji,

Change your database recovery model to simple and truncate the log file.
After doing this go to Management Studio and right click the database
and select the option shrink file. It will give you the minimum size up
to what you can shrink the file.

Select the appropriate log file size and shrink the file. This should
solve your problem.

________________________________________________________________________
_
Thanks & Regards

Prabhu Sundaram
MSSQL Database Administrator

Nuware Technologies | MSSQL Database Services
Phone : 91 80 41247998, 91 80 41239585
Mobile: +919900521990 prabhu.[Email address protected]
________________________________________________________________________
_






-----Original Message-----
From: J.Saraboji
[mailto:mssqldba-ezmlmshield-x39874121.[Email address protected]
Sent: Friday, August 31, 2007 11:06 AM
To: LazyDBA Discussion
Subject: Truncate Database Log Space


Dear All,


I am using SQL server 2005. I have one Database, name of
"Staples" This Database size id 25 MB only but this log
file
size is 4GB.

Now I have to truncate the log space bcoz my hard disk
space is very low. I cant restore other database also
when I
restoring other database its showing " There is insufficient
space in D:\"

I used " DBCC shrinkfile('Staples_Log',1) " commands
also
but
It's not reduced their size.

Please help me.


Advanced Thanks,

JSaraboji.





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page