Backup Plan

Backup plan

For developing a backup strategy,a system admin(“ SA ”) must answer the following

• Techniques will be used to backup database

• Disk Mirroring
• Dump database
• Dump transaction
• Bulk copies of the system table
• Remote backups

• What will be backed up
  • The master database
  • Critical system tables in master database
    • Sysdatabases
    • Sysdevices
    • Syslogins
    • Sysusages
    • Syssrvroles
    • sysloginroles
  • Model database if modified from its default state
  • user database

• when will backups be made
  • Backup the database before and after
    • adding logins
    • adding or dropping devices
    • adding or dropping database's
    • frequently
  • Backup user database and transaction logs on a regular basis
  • Backup database after create index
  • Sample backup schedule
    • Busy database
      • Database every night
      • Transaction log every hour
      • Up-to the minute after the crisis
    • Non-Busy database
      • Database whenever it is warranted
      • Truncate transaction log right before the database backup

• How will the backups be made
  • Document recovery procedures
  • Test recovery procedures prior to genuine server failure
  • Manual Backups
  • Stripes across multiple devices