How do the differential backups work from a backup perspective?
• The catalyst in the differential backup process is issuing a full database backup. • Then the differential backups can be issued at a regular interval depending on your needs. • For example, every 2 hours from 7:00 AM to 7:00 PM or at 7:00 AM, 12:00 PM and 7:00 PM. The schedule is up to you, but keep this in mind during the restoration process outlined in the next section. • If data changes on any one of the pages in an extent, a flag is set at the extent level to indicate that the extent must be backed up. What is sample syntax for a differential database backup?
