Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

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.

share|improve this answer
    
Thank you, @kin! I'll do some tests and report the results. –  Camila Reis Sep 30 '13 at 16:10
    
@CamilaReis if the answer is useful please upvote/mark as answer. –  Kin Sep 30 '13 at 16:33
    
thank you! The tests were successful. –  Camila Reis Oct 2 '13 at 12:30
    
@CamilaReis you can have your question more meaningful by adding what tests (along with scripts) you did and what was the results. It will help future visitors. –  Kin Oct 2 '13 at 20:25
    
Sorry. As my case was simple, I conducted the test did not use scripts, did the tests using the wizard from SQL Server. I did the backup database, removed some files and restored the backup again. And everything was restored without any problem. Thank you! @Kin –  Camila Reis Oct 5 '13 at 15:10
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.