How to Backup and Restore File Group?

Today, I would like to show you how to backup and restore File Group. For this action I prefer using T-SQL, because for me it's faster and easier, but you can use Management Studio. Backup File Group is good if you don't want to backup whole database, bacause DB is huge.

Let's show backup FileGroup "Pigeon" in database Pigeons via T-SQL:

Restore File Group "Pigeon" looks this:

If FG is successfully restored, the result should look like this:

Restore FileGroup result

Note: If restore an entire database in parts first you have to restore the Primary filegroup and then secondary FG!

For Example:

Restore FileGroups and Log

Another article on Monday! Good Bye!