April 19, 2010 at 3:16 pm
Hi all,
Could you help me to find a way to change a Backup Device in a Maintenance Plan BUT from Query Analyzer. The thing is, my company do the Data Base backup using Maintenance Plan and I usually must to create the backup device and I must to Open it and Change it by each Maintenance plan (every week).
Now I'm using a job for create the backup devices by week BUT I need to find a way to change it by each Maintenance Plan but without open it, maybe running an instruction in a Job every week that erase the current backup device and add the new one.
I will appreciate any comments,
WFunes
April 19, 2010 at 7:53 pm
My recommendation: don't use devices, use files instead and let SQL Server date stamp each backup file. What it sounds like you are trying to do is manage the backups in each device by renaming the device and updating the maintenance plan. That's a lot of work when the maintenance plan would do that for you.
What problem are you trying to address with this approach? If you outline what it is you are trying to accomplish, we can probably come up with a better solution.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 20, 2010 at 8:49 am
My company manage maintenance plans by group of apps with backup devices that include the group app names and the number of the week (It work with a Job that create the devices by week), everything works fine BUT Is a lot o work to make the change by each Maintenance Plan every week only for changing the backup device name. So I want find a way to change it automatically.
Thank's in advance,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply