How to differental backup in GUI:
-
Open “SMSS” > expand “Databases” > right-click database > select “Tasks” > select “Back Up…”
-
Select “General” > select “Differential” in “Backup type:”
-
At “Destination” click “Add…” to add multi backup file.
-
Select “Media Options”, we can select backup to existing media set (Append or Overwrite) or new media set.
-
There are some “Reliability” setting: “Verify backup when finished”, “Perform checksum before writing to media” and “Continue on error”
-
Select “Backup Options”, we can assign the name, description, expire datetime to media set.
-
We can also verify backup after backup.
-
We can setup to Compression the backup.
-
We can encrypt the backup media.
How to differential backup in T-SQL:
We will backup database named “AdventureWorks2016” to media set named “COMP_ENCRYPT_DIFF” with 3 backup file with compress and checksum.
