Post reply

Create SQL JOB to backup database and schedule it

  • January 5, 2011 at 9:04 pm

    #245023

    Comments posted to this topic are about the item Create SQL JOB to backup database and schedule it

  • January 6, 2011 at 6:38 am

    #1270046

    Looks interesting. Can you please confirm which versions of SQL Server this will work with: 2000, 2005, 2008, 2008R2 ?

  • January 6, 2011 at 8:04 am

    #1270115

    Can you explain why your script is better than just using the SSMS Maintenance Plan Wizard?

    Thanks,

  • January 6, 2011 at 6:35 pm

    #1270380

    It is always easy to just run the query rather than do it from SSMS Maintenance Plan Wizard.

  • January 6, 2011 at 6:36 pm

    #1270381

    I have tried it for 2005, I think it will work for 2008 also.

  • January 7, 2011 at 7:22 am

    #1270655

    Sure, I agree that its easier to run a script than to click through a wizard every time. But if the user uses the wizard only once, configuring the backup with the schedule and options that (s)he wants, then scripts it out, its much easier than editting your text file by hand.

    Is there a bonus feature in your script that is not included when using the wizard?

  • December 20, 2011 at 11:00 pm

    #1424007

    I find it helpful when for some reason while creating Maintenance plan, I get errors but I can create jobs.

    Is it possible to include the History cleanup/Overwrite option in the same job?

  • May 17, 2016 at 6:58 am

    #1879512

    Thanks for the script.

Viewing 8 posts - 1 through 7 (of 7 total)

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