• Dird (5/21/2013)


    Edit: My guess is that it wouldn't be an issue besides the fact that msdb would continue to grow slightly (since the backup list isn't maintained); is this right?

    I schedule a job on all my instances to delete old backupsets so msdb does not have this type of buildup of old data:

    DECLARE @dt DATETIME ;

    SET @dt = DATEADD(day, -60, GETDATE())

    EXEC msdb.dbo.sp_delete_backuphistory

    @oldest_date = @dt ;

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato