Problem Deleting Backup Data (sp_delete_backuphistory)

• gohil.rajesh

  Newbie

  Points: 1

  More actions

  January 16, 2021 at 10:29 am

  #3834084

  Thanks, Fred Williams  and Patrick Smith for your help, I faced same issue, I have to delete around 2 years of data, I was trying month wise purging, when I started purging, it was taking 30 mins, after completed 5-6 month data, it took around 6-7 hrs, then I added Index and it was taking 10-15 mins.

  Thank you very much.

  Thanks,

  Rajesh Gohil.

• Rachel Gomez

  Valued Member

  Points: 68

  More actions

  March 2, 2022 at 8:57 am

  #3991556

  The first procedure that can be used is sp_delete_backuphistory. This system stored procedure takes a single parameter - a cutoff date. The 2nd system stored procedure allows you to delete historical backup data for a specific database and is called sp_delete_database_backuphistory

  Process to delete  backup data-

  Right click a database in the Object Explorer pane and select the Delete option: In the Delete Object dialog check the Delete backup and restore history information for databases option: Note that using this option will not only delete backup and restore history, it will also drop the whole database.

  Greeting,

  Rachel Gomez