3

I'm preparing to use the FileTable feature in SQL Server 2012, but I'm unclear about how backups work with this feature:

  1. Does a full database backup include FileTable files?

  2. How would I perform the restore of a single file, for example?

Paul White
  • 94,921
  • 30
  • 437
  • 687
Camila Reis
  • 83
  • 1
  • 7

1 Answers1

1

Does a full database backup include FileTable files?

Yes it does include the filetable data. From BOL :

When you use SQL Server to back up a FileTable, the FILESTREAM data is backed up with the structured data in the database. If you do not want to back up FILESTREAM data with relational data, you can use a partial backup to exclude FILESTREAM filegroups.

-

How would I perform the restore of a single file, for example?

You can use the same restore concept and do a point-in-time restore with STOPAT parameter.

For detailed example refer to (Page 319): Backup and Restore for FILESTREAM Databases.

Kin Shah
  • 62,545
  • 6
  • 124
  • 245