Thanks guys,

It worked fine. I emptied the file as suggested by Allen, and removed the file from the database.

My database is working fine...

Thanks Allen for your input.

Do I have to take backup of Transaction Log to truncate the log before I empty it. Please comment.

thanks