How To Backup And Restore DataBase With FILE STREAM Using SMO in C#

Question

How can i backup and restore a database with file stream Using SMO in C#. i found some attributes in Server Class in SMO Like "FilestreamLevel" and "FilestreamShareName" but i do not know how to use them.

please help and thanks for all

Answer 1

There's nothing special you need to do to backup a database that is using FILESTREAM:

Because FILESTREAM is implemented as a varbinary(max) column and integrated directly into the Database Engine, most SQL Server management tools and functions work without modification for FILESTREAM data. For example, you can use all backup and recovery models with FILESTREAM data, and the FILESTREAM data is backed up with the structured data in the database

and as the next statement points out, you actually have to do more to exclude filestream data from the backup:

If you do not want to back up FILESTREAM data with relational data, you can use a partial backup to exclude FILESTREAM filegroups.