What are the challenges you face when working across database platforms? Take the survey

How to delete backup activity history

dsvedarskydsvedarsky Posts: 2
edited December 31, 2007 6:38AM in SQL Backup Previous Versions
Can you tell me how to delete backup activity history in SQL Backup v5


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Thank you for your forum post.

    There are two methods of deleting the backup history:

    1. Run the Stored Procedure sp_delete_backuphistory from Query Analyzer or New Query within SSMS. See the following SQL Server Books On-Line article:

    2. Use SQL Backup, enable the 'Delete old backup history' option available in the SQL Backup GUI->Tools Menu->Option->File Management Tab. SQL Backup will delete the old history depending upon the Older than value set.

    If you have a large amount of backup history, I recommend that use the sp_delete_backuphistory stored procedure.

    Many Thanks

    Eddie Davis
    Technical Support Engineer
    Red Gate Software Ltd
    E-Mail: support@red-gate.com
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.