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 5, 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 6, 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 6, 2011 8:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 1, 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 6, 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 6, 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 7, 2011 7:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 1, 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 4, 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