0

I'm using a SQL-Server 2014 database with filestream enabled. To backup this database I'm using the powershell command Backup-SqlDatabase, which is equivalent (as fas as I know) to T-SQL BACKUP DATABASE. The backup is stored in a "mydatabase.bak" file. My question is very simple: is the filestream backed up as well by this command or do I have to take further steps zu back it up?

Improve this question
1
  • 1
    Regardless of the answer, it does never hurt to actually try a restore at least once.
    – eckes
    Apr 14, 2018 at 9:12

1 Answer 1

Reset to default
2

Backups include both filestream data and relational data. Integrated management is one of the benefits of using filestream/filetable instead of storing files independently.

As suggested by the comments, practice recovery to ensure you can meet your RPO/RTO SLA objectives.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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