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
-
1can you show us the code you have tried/written so far?Davide Piras– Davide Piras2011-07-05 11:34:47 +00:00Commented Jul 5, 2011 at 11:34
Add a comment
|
2 Answers
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.
answered Jul 5, 2011 at 13:10
Damien_The_Unbeliever
241k28 gold badges358 silver badges470 bronze badges
Comments
You refer to this site, which will give you some basic idea to do Database Backup and Restore with SMO
answered Jul 5, 2011 at 11:36
Sai Kalyan Kumar Akshinthala
11.9k8 gold badges45 silver badges68 bronze badges