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
· Share on Twitter

Comments

  • Eddie DEddie D Posts: 1,803 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:
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/bdb56834-616e-47e4-b942-e895d2325e97.htm

    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

    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
    · Share on Twitter
Sign In or Register to comment.