Hi,

My transaction log is full and it has occupied all the space in the disk. Can somebody please, suggest me the best way to empty it.

Thanks a lot

Hi,

If you are able to log on Server, then try to take a backup of the log file with no backup option. then truncate & shrink the log file. This way you can free up the space from the log file which has been occupied on disk.

In case you don't have space to take a backup only try this method. Otherwise dont try this. (Especially if the database you are refering is production data) 1. Try to restart the server. By doing this you make the tempdb recreated. You may gain some space to take a log backup. 2. If the above method too doesn't give enough space to backup. You need to change the recovery model of the database into SImple. Truncate the transaction log using Shrink-> File option. Change the recovery model to the original setting and take a full database backup immediately after. Remember, thsi has its own risks.

 Thanks a lot chetan and perthi. I was able to truncate my transaction log and got my space back.