• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

How to Backup and Restore File Group?

February 3, 2017

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:

 

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

 

For Example:

 

 

 

 

Another article on Monday! Good Bye!

 

 

 

Please reload

RECENT POST
Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon