Constancia icon

SQL_PROC_SYS_BACKUP_LOG

Constancia | PRO | 07/12/15 07:31:09 AM UTC | 0 ⭐ | 4030 👁️ | Never ⏰ | []
PL/SQL |

570 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
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

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    •