vaciar log

SELECT name, size FROM sys.database_files;

USE Base_datos
GO

CHECKPOINT
GO
CHECKPOINT
GO
CHECKPOINT
GO

BACKUP LOG Base_datos WITH TRUNCATE_ONLY
GO

DBCC SHRINKFILE (basedatos_db_log)