Create SQL JOB to backup database and schedule it

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Bharat Panthee » Create SQL JOB to backup database and...

Create SQL JOB to backup database and schedule it

Rate Topic

Display Mode

Topic Options

Author

Message

Bharat Panthee

Posted Wednesday, January 05, 2011 9:04 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 28, 2012 11:28 AM
Points: 444, Visits: 157

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

Post #1043462

paul 74500

Posted Thursday, January 06, 2011 6:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 10, 2012 12:31 PM
Points: 1, Visits: 13

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

Post #1043704

Patrick2525

Posted Thursday, January 06, 2011 8:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 01, 2013 10:16 AM
Points: 117, Visits: 180

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

Thanks,

Post #1043784

Bharat Panthee

Posted Thursday, January 06, 2011 6:35 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 28, 2012 11:28 AM
Points: 444, Visits: 157

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

Post #1044096

Bharat Panthee

Posted Thursday, January 06, 2011 6:36 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 28, 2012 11:28 AM
Points: 444, Visits: 157

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

Post #1044097

Patrick2525

Posted Friday, January 07, 2011 7:22 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 01, 2013 10:16 AM
Points: 117, Visits: 180

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?

Post #1044410

nirajkrm

Posted Tuesday, December 20, 2011 11:00 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:44 PM
Points: 1, Visits: 131

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?

Post #1224867

« Prev Topic | Next Topic »

Permissions