SQL - Depuración de tablas

declare @dbname varchar(255)

declare @logfile varchar(255)

select @dbname = db_name()

select @logfile = name from sysfiles where filename like '%.ldf'

backup log @dbname with no_log

dbcc shrinkfile (@logfile,1)