Home Forums SQL Server 2005 Administering Backup RE: Backup
tt-615680
SSCertifiable
Points: 7835
More actions
August 24, 2010 at 8:09 am
#1211029
This is the stored procedure that runs the 'Truncate Transaction log'
ALTER PROCEDURE [dbo].['name of stored procedure']
AS
BACKUP LOG 'Databasename'
WITH
TRUNCATE_ONLY