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.




MS Sql Server LazyDBA home page