Microsoft SQL Server – Transact-SQL the ’sp_delete_backuphistory‘ stored procedure is the standard and supported method to purge old data from the backup and restore history tables in the msdb database

USE msdb;
GO
EXEC dbo.sp_delete_backuphistory @oldest_date = ‚YYYY-MM-DD‘;
GO

Leave a Reply

You must be logged in to post a comment.