Home >> Dot Net Interview Questions >> Mix Dot Net Questions

How to delete backup history for past day

Posted on May 21st , 2009 by Admin

Here i have given a syntax to delete backup history of database.

USE msdb

GO

DECLARE @DaysToKeepHistory DATETIME

SET @DaysToKeepHistory = CONVERT(VARCHAR(10), DATEADD(dd, -30, GETDATE()), 101)

EXEC sp_delete_backuphistory @DaysToKeepHistory

GO