How to list table and filegroup relation in T-SQL:
How to Filegroup backup in GUI:
-
Open “SMSS” > expand “Databases” > right-click database > select “Properties”
-
Select “Options” > make sure “Full” or “Differential” in “Recovery model:”
-
Right-click database > select “Tasks” > select “Back Up…”
-
Select “General” > select “Full” or “Differential” in “Backup type:”
-
Select “Files and filegroups:” in “Backup component:”
-
Click files and/or filegroups which you need to backup.
-
At “Destination” click “Add…” to add multi backup file.
-
If we take File/Filegroup 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 Filegroup backup in T-SQL:
