Scheduling Backup Job

Backup maintenance suggestions:

  • Configure/Schedule a Backup Job within SQL Manager on a nightly basis.  
  • Then it would be up to System Administrator to maintain and cycle through the backups created.  
  • For example:  you might go through and just keep a Rolling weeks worth of backups available, each day you could go and purge off the oldest backup (which would be approx 1 week old). 
  • In addition to the rolling weeks worth of backup we would also suggest picking maybe the 1st of every month and keep those backups on a permanent basis or a Rolling Year or Rolling 6 months.  This could come in handy down the road if some major situation occurs or some clients even refer back to those monthly backups and use them for accounting evaluations.  

 


 Download the attached script  <<BackupScript2>> at the end of this article.

Copy the script that you have made the changes to. 
  
 In the Object Explorer pane, under the SQL Server Agent node, right click Jobs and select New job from the context menu:  
 Name the New Job . . . this example we used ManexLiveBackup  
 Select Steps and select New  
 Name the Step. . . in this example we used "RunBackupScript"

Select the Database

and Paste in the script from first step above.		  
 Select Schedule and then New  
 Name the Schedule  . . in this example we named it "DailyManexBackup"

Select the Frequency

Select the Time 

Etc . . . 



Depress OK and confirm that the Daily backup has been generated in the file path you specified.