You may sometimes need to empty a database's Transaction Logs.
It is important to back up the database beforehand, since otherwise, if you want to restore it using another type of backup, it is very likely that it will not work correctly. Transaction logs safeguard data consistency , so if you do not restore a backup, you may encounter problems.
Query to empty the Transaction Logs:
ALTER DATABASE nombre_de_la_base_de_datos SET RECOVERY SIMPLE
declare @log_File_Name varchar(200)
select @log_File_Name = name from sysfiles where filename like '%LDF'
declare @i int = FILE_IDEX ( @log_File_Name)
dbcc shrinkfile ( @i , 1)
ALTER DATABASE nombre_de_la_base_de_datos SET RECOVERY FULL