• Database Backup and Recovery

  Use of SQL Server to do the following:

  1.  
  2. Perform a proper backup and recovery using SSMS.
  3. Perform a proper backup and recovery using T-SQL.
  4. Set up an automated backup process to run a full backup every Sunday at midnight.
  5. Set up the automated process to create incremental backups on all other days other than Sunday.

  Part 2: Database Backup and Recovery Plan

  use a step-by-step procedure for use by subsequent developers to guide them to proper backup and restore the data files. Include supporting graphics to illustrate important or complex aspects of the backup.

   

•