How can we help you today? How can we help you today?

How to delete backup activity history

Can you tell me how to delete backup activity history in SQL Backup v5
dsvedarsky
0

Comments

1 comment

Sort by
  • Eddie D
    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 D
    0

Add comment

Please sign in to leave a comment.