deleting a backup device

[jjsaper0729]

I have created two backup devices for a database: 1 for the data and 1 for the logs. I back up transaction logs to the device over the course of a day and then do a differential backup for the data nightly.

Once a week, I do a full backup of the database. After the full backup is done, I want to delete the log file device since it's no longer needed. I've done it before, but haven't in a while and can't remember the syntax in the job step setup. Can someone please refresh me?

I know it's a CmdExec job, but the syntax of the step is eluding my memory.

Thanks for any help.

[jjsaper0729]

just bumping for assistance.

[jjsaper0729]

re-bumping... any assistance would be greatly appreciated.

[heathensong]

why delete the device? don't you want to leave it there to use it again. just set the backup log init to overwrite the previous log file.