USE [METRICAS]
GO

-- ****** Object:  StoredProcedure [dbo].[PROC_SYS_BACKUP_LOG]  
-- ****** Autor: Jorge Sánchez  
-- ****** Script Date: 07/12/2015 09:29:21 
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[PROC_SYS_BACKUP_LOG] AS

DECLARE
@base AS VARCHAR(20),
@log AS VARCHAR(20)

BEGIN

	SELECT @log = RTRIM(name) FROM sysfiles WHERE FILEID = 2
	SELECT @base = RTRIM(name) FROM sysfiles WHERE FILEID = 1
	
	SELECT @base = REPLACE(@base,'_DATA','')
		
	BACKUP LOG @base WITH TRUNCATE_ONLY
	DBCC SHRINKFILE(@log, 3)

END

GO