{"id":16093,"date":"2021-04-22T19:46:11","date_gmt":"2021-04-22T17:46:11","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/"},"modified":"2025-10-01T11:52:38","modified_gmt":"2025-10-01T09:52:38","slug":"sql-server-how-to-delete-the-msdb-backup-history-kindly","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/","title":{"rendered":"SQL Server: How to delete the msdb backup history kindly"},"content":{"rendered":"

This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged.<\/p>\n

I already wrote a post<\/a> on this topic and provided a small PowerShell script using dbatools<\/a> to clean the backup history.
\nThe issue with sp_delete_backuphistory or Remove-DbaDbBackupRestoreHistory is that the operation is done as one transaction and this could badly impact the msdb transaction log file.<\/p>\n

Remember you can have a look at the code behind a system stored procedure using sp_helptext<\/a>.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
use msdb<\/code><\/div>\n
go<\/code><\/div>\n
exec<\/code> sp_helptext sp_delete_backuphistory<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The code for sp_delete_backuphistory looks like this:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n<\/td>\n
\n
\n
CREATE<\/code>   PROCEDURE<\/code> sp_delete_backuphistory  <\/code><\/div>\n
  <\/code>@oldest_date datetime  <\/code><\/div>\n
AS<\/code><\/div>\n
BEGIN<\/code><\/div>\n
  <\/code>SET<\/code> NOCOUNT <\/code>ON<\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>DECLARE<\/code> @backup_set_id <\/code>TABLE<\/code>      (backup_set_id <\/code>INT<\/code>)  <\/code><\/div>\n
  <\/code>DECLARE<\/code> @media_set_id <\/code>TABLE<\/code>       (media_set_id <\/code>INT<\/code>)  <\/code><\/div>\n
  <\/code>DECLARE<\/code> @restore_history_id <\/code>TABLE<\/code> (restore_history_id <\/code>INT<\/code>)  <\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>INSERT<\/code> INTO<\/code> @backup_set_id (backup_set_id)  <\/code><\/div>\n
  <\/code>SELECT<\/code> DISTINCT<\/code> backup_set_id [...]<\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>INSERT<\/code> INTO<\/code> @media_set_id (media_set_id)  <\/code><\/div>\n
  <\/code>SELECT<\/code> DISTINCT<\/code> media_set_id [...] <\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>INSERT<\/code> INTO<\/code> @restore_history_id (restore_history_id)  <\/code><\/div>\n
  <\/code>SELECT<\/code> DISTINCT<\/code> restore_history_id [...]  <\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>BEGIN<\/code> TRANSACTION<\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>DELETE<\/code> FROM<\/code> msdb.dbo.backupfile  <\/code><\/div>\n
  <\/code>WHERE<\/code> backup_set_id <\/code>IN<\/code> (<\/code>SELECT<\/code> backup_set_id  <\/code><\/div>\n
                          <\/code>FROM<\/code> @backup_set_id)  <\/code><\/div>\n
  <\/code>IF (@@error > 0)  <\/code><\/div>\n
    <\/code>GOTO<\/code> Quit  <\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>DELETE<\/code> FROM<\/code> msdb.dbo.backupfilegroup  <\/code><\/div>\n
  <\/code>WHERE<\/code> backup_set_id <\/code>IN<\/code> (<\/code>SELECT<\/code> backup_set_id  <\/code><\/div>\n
                          <\/code>FROM<\/code> @backup_set_id)  <\/code><\/div>\n
  <\/code>IF (@@error > 0)  <\/code><\/div>\n
    <\/code>GOTO<\/code> Quit  <\/code><\/div>\n
  <\/code><\/div>\n
  <\/code>[...]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In order to clean up the backup history while minimizing the impact on the size of the transaction log file, the operation should be done in small chunks.<\/p>\n

Here is the small T-SQL script that will do the job:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n<\/td>\n
\n
\n
use msdb<\/code><\/div>\n
go<\/code><\/div>\n
<\/div>\n
declare<\/code> @retentionDate datetime = DATEADD(<\/code>MONTH<\/code>, -3, getdate())<\/code><\/div>\n
declare<\/code> @oldest_date datetime = (<\/code>select<\/code> min<\/code>(backup_start_date) <\/code>from<\/code> msdb.dbo.backupset)<\/code><\/div>\n
<\/div>\n
while (@oldest_date  < @retentionDate)<\/code><\/div>\n
begin<\/code><\/div>\n
    <\/code>print <\/code>'sp_delete_backuphistory '<\/code> + <\/code>CAST<\/code>(@oldest_date <\/code>AS<\/code> varchar<\/code>)<\/code><\/div>\n
    <\/code>exec<\/code> msdb.dbo.sp_delete_backuphistory @oldest_date<\/code><\/div>\n
<\/div>\n
    <\/code>--  Delete by 1 week increments<\/code><\/div>\n
    <\/code>set<\/code> @oldest_date = DATEADD(WEEK, 1, @oldest_date)<\/code><\/div>\n
<\/div>\n
    <\/code>checkpoint<\/code><\/div>\n
end<\/code><\/div>\n
<\/div>\n
exec<\/code> msdb.dbo.sp_delete_backuphistory @retentionDate<\/code><\/div>\n
go<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The sp_delete_backuphistory procedure is called in 1-week increments from the oldest entry in msdb.dbo.backupset until the retention date which I set to 3 months.
\nAn important point here is the checkpoint command which actually performs a manual checkpoint<\/a> and helps to keep the impact on the transaction log size at a minimum when the database is in the SIMPLE recovery model. You can read more about this technic in this great writing<\/a> from Aaron Bertrand.<\/p>\n

If you don’t already have one, I would recommend creating a Job on your SQL Server instance that will call sp_delete_backuphistory weekly or fortnightly. This can be a standard Job on all your servers.<\/p>\n

Here is the script for such a Job with its schedule. The retention is set to 6 months of backup history.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n<\/td>\n
\n
\n
USE [msdb]<\/code><\/div>\n
GO<\/code><\/div>\n
<\/div>\n
BEGIN<\/code> TRANSACTION<\/code><\/div>\n
DECLARE<\/code> @ReturnCode <\/code>INT<\/code> = 0;<\/code><\/div>\n
<\/div>\n
DECLARE<\/code> @jobId <\/code>BINARY<\/code>(16)<\/code><\/div>\n
EXEC<\/code> @ReturnCode =  msdb.dbo.sp_add_job @job_name=N<\/code>'DBA_MAINTENANCE_BACKUP_HISTORY'<\/code>, <\/code><\/div>\n
        <\/code>@enabled=1, <\/code><\/div>\n
        <\/code>@notify_level_eventlog=0, <\/code><\/div>\n
        <\/code>@notify_level_email=0, <\/code><\/div>\n
        <\/code>@notify_level_netsend=0, <\/code><\/div>\n
        <\/code>@notify_level_page=0, <\/code><\/div>\n
        <\/code>@delete_level=0, <\/code><\/div>\n
        <\/code>@description=N<\/code>'Purge backup history'<\/code>, <\/code><\/div>\n
        <\/code>@category_name=N<\/code>'Database Maintenance'<\/code>, <\/code><\/div>\n
        <\/code>@owner_login_name=N<\/code>'sa'<\/code>, @job_id = @jobId <\/code>OUTPUT<\/code><\/div>\n
IF (@@ERROR <> 0 <\/code>OR<\/code> @ReturnCode <> 0) <\/code>GOTO<\/code> QuitWithRollback<\/code><\/div>\n
<\/div>\n
EXEC<\/code> @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N<\/code>'DBA_MAINTENANCE_BACKUP_HISTORY_STEP'<\/code>, <\/code><\/div>\n
        <\/code>@step_id=1, <\/code><\/div>\n
        <\/code>@cmdexec_success_code=0, <\/code><\/div>\n
        <\/code>@on_success_action=1, <\/code><\/div>\n
        <\/code>@on_success_step_id=0, <\/code><\/div>\n
        <\/code>@on_fail_action=2, <\/code><\/div>\n
        <\/code>@on_fail_step_id=0, <\/code><\/div>\n
        <\/code>@retry_attempts=0, <\/code><\/div>\n
        <\/code>@retry_interval=0, <\/code><\/div>\n
        <\/code>@os_run_priority=0, @subsystem=N<\/code>'TSQL'<\/code>, <\/code><\/div>\n
        <\/code>@command=N<\/code>'declare @retentionDate datetime = DATEADD(MONTH, -6, getdate());<\/code><\/div>\n
exec msdb.dbo.sp_delete_backuphistory @retentionDate;'<\/code>, <\/code><\/div>\n
        <\/code>@database_name=N<\/code>'msdb'<\/code>, <\/code><\/div>\n
        <\/code>@flags=0<\/code><\/div>\n
IF (@@ERROR <> 0 <\/code>OR<\/code> @ReturnCode <> 0) <\/code>GOTO<\/code> QuitWithRollback<\/code><\/div>\n
EXEC<\/code> @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1<\/code><\/div>\n
IF (@@ERROR <> 0 <\/code>OR<\/code> @ReturnCode <> 0) <\/code>GOTO<\/code> QuitWithRollback<\/code><\/div>\n
EXEC<\/code> @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @<\/code>name<\/code>=N<\/code>'WeeklySchedule_Sunday_10pm'<\/code>, <\/code><\/div>\n
        <\/code>@enabled=1, <\/code><\/div>\n
        <\/code>@freq_type=8, <\/code><\/div>\n
        <\/code>@freq_interval=1, <\/code><\/div>\n
        <\/code>@freq_subday_type=1, <\/code><\/div>\n
        <\/code>@freq_subday_interval=0, <\/code><\/div>\n
        <\/code>@freq_relative_interval=0, <\/code><\/div>\n
        <\/code>@freq_recurrence_factor=1, <\/code><\/div>\n
        <\/code>@active_start_date=20210422, <\/code><\/div>\n
        <\/code>@active_end_date=99991231, <\/code><\/div>\n
        <\/code>@active_start_time=220000, <\/code><\/div>\n
        <\/code>@active_end_time=235959, <\/code><\/div>\n
        <\/code>@schedule_uid=N<\/code>'f41b6a99-3d5d-49d7-871b-5e8a9ac2c0eb'<\/code><\/div>\n
IF (@@ERROR <> 0 <\/code>OR<\/code> @ReturnCode <> 0) <\/code>GOTO<\/code> QuitWithRollback<\/code><\/div>\n
EXEC<\/code> @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N<\/code>'(local)'<\/code><\/div>\n
IF (@@ERROR <> 0 <\/code>OR<\/code> @ReturnCode <> 0) <\/code>GOTO<\/code> QuitWithRollback<\/code><\/div>\n
COMMIT<\/code> TRANSACTION<\/code><\/div>\n
GOTO<\/code> EndSave<\/code><\/div>\n
QuitWithRollback:<\/code><\/div>\n
    <\/code>IF (@@TRANCOUNT > 0) <\/code>ROLLBACK<\/code> TRANSACTION<\/code><\/div>\n
EndSave:<\/code><\/div>\n
GO<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n\n\n

Written by Steven Naudet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged. I already wrote a post on this topic and provided a small PowerShell script using dbatools to clean the backup history. The issue with sp_delete_backuphistory […]<\/p>\n","protected":false},"author":26,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[1887,2550,521,533],"type_dbi":[],"class_list":["post-16093","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-sql-server","tag-backup-history","tag-sql-server-2","tag-t-sql","tag-transaction-log"],"acf":[],"yoast_head":"\nSQL Server: How to delete the msdb backup history kindly - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server: How to delete the msdb backup history kindly\" \/>\n<meta property=\"og:description\" content=\"This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged. I already wrote a post on this topic and provided a small PowerShell script using dbatools to clean the backup history. The issue with sp_delete_backuphistory […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-22T17:46:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-01T09:52:38+00:00\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server: How to delete the msdb backup history kindly\",\"datePublished\":\"2021-04-22T17:46:11+00:00\",\"dateModified\":\"2025-10-01T09:52:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/\"},\"wordCount\":305,\"commentCount\":0,\"keywords\":[\"Backup history\",\"SQL Server\",\"T-SQL\",\"transaction log\"],\"articleSection\":[\"Database Administration & Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/\",\"name\":\"SQL Server: How to delete the msdb backup history kindly - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2021-04-22T17:46:11+00:00\",\"dateModified\":\"2025-10-01T09:52:38+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server: How to delete the msdb backup history kindly\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server: How to delete the msdb backup history kindly - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server: How to delete the msdb backup history kindly","og_description":"This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged. I already wrote a post on this topic and provided a small PowerShell script using dbatools to clean the backup history. The issue with sp_delete_backuphistory […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/","og_site_name":"dbi Blog","article_published_time":"2021-04-22T17:46:11+00:00","article_modified_time":"2025-10-01T09:52:38+00:00","author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server: How to delete the msdb backup history kindly","datePublished":"2021-04-22T17:46:11+00:00","dateModified":"2025-10-01T09:52:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/"},"wordCount":305,"commentCount":0,"keywords":["Backup history","SQL Server","T-SQL","transaction log"],"articleSection":["Database Administration & Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/","name":"SQL Server: How to delete the msdb backup history kindly - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-04-22T17:46:11+00:00","dateModified":"2025-10-01T09:52:38+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-how-to-delete-the-msdb-backup-history-kindly\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server: How to delete the msdb backup history kindly"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16093"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16093\/revisions"}],"predecessor-version":[{"id":40607,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16093\/revisions\/40607"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16093"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}