Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Create SQL JOB to backup database and schedule it Expand / Collapse
Author
Message
Posted Wednesday, January 05, 2011 9:04 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 3:48 PM
Points: 444, Visits: 162
Comments posted to this topic are about the item Create SQL JOB to backup database and schedule it
Post #1043462
Posted Thursday, January 06, 2011 6:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, January 06, 2011 8:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Thursday, January 06, 2011 6:35 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 3:48 PM
Points: 444, Visits: 162
It is always easy to just run the query rather than do it from SSMS Maintenance Plan Wizard.
Post #1044096
Posted Thursday, January 06, 2011 6:36 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 3:48 PM
Points: 444, Visits: 162
I have tried it for 2005, I think it will work for 2008 also.
Post #1044097
Posted Friday, January 07, 2011 7:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, December 20, 2011 11:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 8:35 AM
Points: 1, Visits: 145
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 »

Add to briefcase

Permissions Expand / Collapse