Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    28

    Unanswered: How do I clear out available restore points for MSSQL db's?

    I was messing around with backup strategies today at work while contemplating my other db issues.

    In doing so, I've made a list of backups that don't truly exist anymore (I deleted the 'backup device' (bleh.bak).

    Here's an image, stolen from technet's articles.

    http://www.microsoft.com/library/med...pc1106_big.gif

    See that list of restore points? Mine is full of restore points that have absolutely no meaning in them for a DB I made to test out (testDB).

    Is there a way to clean those out?

  2. #2
    Join Date
    Aug 2006
    Posts
    28
    seems the key is sp_delete_backuphistory.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •