Homework answers / question archive / Part 1: Database Backup and Recovery Use of SQL Server to do the following:   Perform a proper backup and recovery using SSMS

Part 1: Database Backup and Recovery Use of SQL Server to do the following:   Perform a proper backup and recovery using SSMS

Computer Science

Share With

Part 1: 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.