SQL_PROC_SYS_BACKUP_LOG

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