Changing a Maintenance Plan

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Changing a Maintenance Plan

Changing a Maintenance Plan

Rate Topic

Display Mode

Topic Options

Author

Message

willian.funes

Posted Monday, April 19, 2010 3:16 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:19 AM
Points: 36, Visits: 126

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

Post #906371

Jeffrey Williams 3188

Posted Monday, April 19, 2010 7:53 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 11:21 AM
Points: 4,317, Visits: 9,216

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
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

Post #906451

willian.funes

Posted Tuesday, April 20, 2010 8:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:19 AM
Points: 36, Visits: 126

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,

Post #906915

« Prev Topic | Next Topic »

Permissions