Delete Old Backupset From Device

  • I want to delete old backup sets from a device. How can I do it?

  • What kind of device? Tape or hard drive?

    Tape: erase the tape.

    Hard Drive: delete the file.

    -SQLBill

  • It is Dard Drive device.

    I do not want to erase all backup sets. I want to keep recent backup sets in it. and i want to erase old ones.

  • You can't erase only one backup set from the backup device. You can overwrite all the backup sets with a new backup or append all the backups to the existing.

    What you should do is execute a new backup and overwrite all the other backups, with the init option of the backup sentence.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply