How to Log backup in GUI:
-
Open “SMSS” > expand “Databases” > right-click database > select “Properties”
-
Select “Options” > make sure “Full” in “Recovery model:”
-
Right-click database > select “Tasks” > select “Back Up…”
-
Select “General” > select “Differential” in “Backup type:”
-
At “Destination” click “Add…” to add multi backup file.
-
If we take Log 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 also verify backup after backup.
-
We can setup to Compression the backup.
-
We can encrypt the backup media.
How to Log backup in T-SQL:
We will backup LOG of database named “AdventureWorks2016” to media set named “COMP_ENCRYPT_LOG” with 3 backup file with compress and checksum.
