Backup maintenance suggestions:
- Configure and schedule a backup job within SQL manager on a nightly basis.
- It will be up to the system administrator to maintain and cycle through the backups created.
- Consider the following example: you might go through and just keep a rolling weeks worth of backups available, and each day you could purge off the oldest backup (which would be approximately one week old).
- In addition to the rolling weeks worth of backup, we would also suggest picking the 1st of every month and keep those backups on a permanent basis, or a rolling year or a rolling 6 months. This could come in handy down the road if some major situation occurs or some clients could even refer back to those monthly backups and use them for accounting evaluations.
Download the attached script at the end of this article called, "BackupScript2.sql"
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. The example below uses the name "ManexLiveBackup"
Select "Steps" and select "New."
Name the step. The example below used the name "RunBackupScript"
Select the database and paste in the script from step one above.
Select "Schedule," and then select "New."
Name the schedule. The below example use the name "DailyManexBackup"
Select the frequency, time, etc.
Depress OK and confirm that the daily backup has been generated in the file path you specified.
Attachment:
