By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,838 Members | 2,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,838 IT Pros & Developers. It's quick & easy.

deleting a backup device

P: 4
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.
Oct 18 '06 #1
Share this Question
Share on Google+
3 Replies

P: 4
just bumping for assistance.
Oct 19 '06 #2

P: 4
re-bumping... any assistance would be greatly appreciated.
Oct 25 '06 #3

P: 5
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.
Oct 27 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.