How to full backup in GUI:
-
Open “SMSS” > expand “Databases” > right-click database > select “Tasks” > select “Back Up…”
-
Select “General” > select “Full” in :Backup type:”
-
At “Destination” click “Add…” to add multi backup file.
-
If we take full backup out of scheduler, we can click “Copy-only backup” checkbox.
-
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 “Coninut on error”
-
Select “Backup Options”, we can assign the name, description, expire datetime to media set.
-
We can setup to Compression the backup.
-
We can encrypt the backup media.
How to full backup in T-SQL:
We will backup database named “AdventureWorks2016” to media set named “COMP_ENCRYPT_FULL” with 3 backup file with compress and checksum.
