Microsoft SQL Server – reduces the size of the backup and restore history tables by deleting the entries for backup sets older than the specified date

Microsoft SQL Server – more rows are added to the backup and restore history tables after each backup or restore operation is performed therefore we recommend that you periodically execute sp_delete_backuphistory

 

The following example deletes all entries that are older than January 14, 2023, 12:00 A.M. in the backup and restore history tables

USE msdb;
GO
EXEC sp_delete_backuphistory @oldest_date = ‚2023-01-14‘;
GO

This entry was posted on Sonntag, März 23rd, 2025 at 16:33 and is filed under Administration, SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.