LOTHAIR Backup Procedures

SQL Server Maintenance Plan

  • within SQL Server Management Studio under "Management"
  • Name: Daily Backups
  • Creates a daily full backup of databases SCCM2012 and TAMU_CAC
  • Backups created in E:\Backups (each DB backups stored in  own sub-directory
  • Deletes Backups older then 4 weeks
  • Files rsync'ed to HFB nightly

New Production Database

  • Modify the maintenance plan to include the new DB
  • Modify the HFB verification script to check for the new DB backups