Post reply

Set up a maintenance plan backup to init media?

  • December 23, 2008 at 8:21 am

    #133292

    I am trying to set up a maintenance plan to backup several DBs from a SQL2000 server. Is there any way to set up the plan to initialize the media within the maintenance plan?

    Or, can I alter the T-SQL statement in the job that actually does the work, possibly adding something to the end of the statement, or even another step, perhaps a step to backup the Northwind DB (nice and small), and init the media then, followed by the actual Maintenance plan step?

    Thanks,

    Jason A.

  • December 23, 2008 at 8:44 am

    #916810

    You can't alter the maintenance plan beyond the options that are there. You could add a step to the job once it's created, but if you changed the maintenance plan, I don't think it would persist.

    Actually I changed one of my jobs and it errored out.

    Are you looking to INIT to tape? This is not recommended. You really want to back up to disk, even a $100 USB drive and then just pull the files to tape.

  • December 23, 2008 at 8:53 am

    #916823

    The issue I've got is, I need to backup directly to tape for now, as the backup software that was purchased with the server went south (and the client doesn't know where the media went to reload that), and MS Backup doesn't recognize the tape drive.

    Is there an easy way, to backup directly to tape, from within SQL, that I can schedule?

    I've got the client looking for the media, but I'm not counting on them finding it. In which case, they'll have two options, either purchase a new copy of the backup software, or we continue with the current setup. My recommendation to them will be to purchase, as they have other data that needs to be backed up...

    Thanks,

    Jason

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

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