Full Backup in MS SQL

MSSQL-Feature-Image
How to full backup in GUI:
  1. Open “SMSS” > expand “Databases” > right-click database > select “Tasks” > select “Back Up…”
  2. Select “General” > select “Full” in :Backup type:”
  3. At “Destination” click “Add…” to add multi backup file.
  4. If we take full backup out of scheduler, we can click “Copy-only backup” checkbox.
  5. Select “Media Options”, we can select backup to existing media set (Append or Overwrite) or new media set.
  6. There are some “Reliability” setting: “Verify backup when finished”, “Perform checksum before writing to media” and “Coninut on error”
  7. Select “Backup Options”, we can assign the name, description, expire datetime to media set.
  8. We can setup to Compression the backup.
  9. 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.

Author: Joe Chan