use master
ALTER DATABASE ELSYS022007 SET RECOVERY FULL;
GO
EXEC sp_addumpdevice 'disk', 'ELSYS022007_dat', 'D:\Microsoft SQL Server\MSSQL\BACKUP\ELSYS022007_dat.dat'
GO
EXEC sp_addumpdevice 'disk', 'ELSYS022007_log', 'D:\Microsoft SQL Server\MSSQL\BACKUP\ELSYS022007_log.dat'
GO
BACKUP DATABASE ELSYS022007 TO ELSYS022007_dat
GO
BACKUP LOG ELSYS022007 TO ELSYS022007_log
GO
BACKUP LOG ELSYS022007 WITH TRUNCATE_ONLY
GO
sp_dropdevice 'ELSYS022007_dat'
GO
sp_dropdevice 'ELSYS022007_log'
GO

USE ELSYS022007
SELECT name FROM dbo.sysfiles
GO

USE ELSYS022007
DBCC SHRINKFILE (ELSYS022007Log,35)
GO

I onda rukom podesim tran log na maksimum 50MB