Dear Friends

Of all the methods suggested by different friends, the method suggested by JP de Jong has reduced the log space.

Any way I learnt many commands from all of...

Thanks for the reply.

I used the commands like

DBCC shrinkdatabase

DBCC shrinkfile.

But still I could not shrink the log file. Is there any other way out.Please give suggestions

Regards

TT

To restore the backup, I need to have minimum of 1.5 GB of free space,equivalent to the size of the database, in the hard disk. So still the problem is...